last access to database

db2cap · #1 (**permalink**) 08-11-10, 06:28

Hi,
I am working on DB2 v9.1 on AIX.
Is there a way to find last access time to a particular database. Audit is not enabled. Is there some other way?

db2girl · #2 (**permalink**) 08-11-10, 22:10

The best I can think of is to check the date/time of when the transaction logs were last modified.

nvk@vhv · #3 (**permalink**) 08-12-10, 07:40

Quote:

Originally Posted by db2girl

The best I can think of is to check the date/time of when the transaction logs were last modified.

I don't think, that this very accurate. If there are still runstats or backup jobs, then you get the dates from these jobs, but not the last user access.

db2cap · #4 (**permalink**) 08-12-10, 08:06

Bella thanks for your reply but nvk@vhv is right. That will not give me the expected answer as backup jobs are getting executed on a daily basis.

db2girl · #5 (**permalink**) 08-12-10, 10:10

Yes, it's not very accurate. But I'm not sure what else you can check without capturing any information. Starting with v9.7 fp1, lastused column was added to some catalog tables.