Hi guys,

Can we find the last access time on a table.
We need a list of access time on tables in a database


Thanks
DBFinder

You need auditing facilities for that. Obviously, DB2 doesn't track such information because it is a hot-spot and potential bottle-neck. Also, you have to decide which semantics you want to have:
- only data modifications
- also read operations
- what happens with rolled back transactions? include those, too?