Tracking Time When Last Accessed

Database
Enthusiast

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

Tags (1)
4 REPLIES
Enthusiast

Re: Tracking Time When Last Accessed

Hi Kishore,

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

Thanks

Fan

Re: Tracking Time When Last Accessed

Hi,

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

Thanks,

Taha Habib

Junior Contributor

Re: Tracking Time When Last Accessed

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+).

Fan

Re: Tracking Time When Last Accessed

Thanks Dieter :)