Which DBC table(s) can be used to know when an database object (table/view/store proc/macro) was last accesed (for sel/insert/update etc.) ?
I can use the DBCLogTbl for that purpose to see the query fired using that table, but is there any other DBC table that specifically stores this information.
If you look at dbc.tables, there are two columns which give access count and last access timestamp.
"?" is the default for displaying NULL in BTEQ and SQL Assistant.
If LastAccessTimestamp is NULL use count collection is not enabled on this system (pre-TD14.10) or on this database (TD14.10+).