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
------------------------------

#Informix

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
------------------------------