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.
 
Thanks,
Kishore

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

Taha 3 posts Joined 07/13
08 Jan 2016

Hi,
Does anybody know what "?" in lastaccesstimestamp column signify?
 
Thanks,
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+).

Dieter

Taha 3 posts Joined 07/13
25 Feb 2016

Thanks Dieter :)
 

You must sign in to leave a comment.