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

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