Last Accessed Date for a Table

Neharao · #1 (**permalink**) 07-18-08, 08:28

How can we know the Table Last Accessed ( Either Selected or Updated) Date in Db2.

przytula_guy · #2 (**permalink**) 07-18-08, 15:16

select on table is never logged and is very difficult to find back
upate leaves a trace in the log and this could be analyzed with recovery expert
or using auditing

stolze · #3 (**permalink**) 07-19-08, 04:15

I guess that's a situation where db2audit may play a role in...

Internet Services

Web Development

Digital Marketing

Consumer Tech