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
------------------------------
Original Message:
Sent: Fri September 10, 2021 03:58 AM
From: John Smith
Subject: database object last access
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