Informix

Expand all | Collapse all

database object last access

  • 1.  database object last access

    Posted Fri September 10, 2021 03:59 AM
    Hello to All

    I need to know the date of last access for a table, index ..etc  , i thought it was systables.ustlowts column but when i red the description it mentions when the last statistics were done.

    https://www.ibm.com/docs/en/informix-servers/12.10?topic=tables-systables

    thanks for your help

    Regards


    ------------------------------
    John Smith
    ------------------------------


  • 2.  RE: database object last access

    IBM Select
    Posted Fri September 10, 2021 05:39 AM
    There's sysptnhdr.acc_or_mod_tm (and sysactptnhdr.pn_acc_or_mod_tm) in sysmaster, available since 14.10.xC5.

    For data partitions this records time of last *modifying* access.
    For index partitions it records last access regardless of 'modifying'.

    This used to be idx_acc_tm / pn_idx_acc_tm since 12.10.xC10 and applied to index partitions only.

    I hope those values' accuracy doesn't get blurred by things like Update Statistics/AUS, compression estimation, onchecks etc.
    Let us know how helpful they are!

    HTH,
     Andreas

    ------------------------------
    Andreas Legner
    ------------------------------