All Forums Database
Kishore_1 208 posts Joined 03/10
05 May 2013
Tracking Time When Last Accessed

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.

Harpreet Singh 101 posts Joined 10/11
06 May 2013

Hi Kishore,
If you look at dbc.tables, there are two columns which give access count and last access timestamp.

Taha 3 posts Joined 07/13
08 Jan 2016

Does anybody know what "?" in lastaccesstimestamp column signify?
Taha Habib

dnoeth 4628 posts Joined 11/04
08 Jan 2016

Hi Taha,
"?" 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+).


Taha 3 posts Joined 07/13
25 Feb 2016

Thanks Dieter :)

You must sign in to leave a comment.