we need to know when a DB2 table (or ts because we have only one table per TS) has been used for the last time.
Does anyone know what is the best way to get this information?
Pinned topic How to know the last time a DB2 table has been accessed.
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-05T08:51:08Z at 2013-01-05T08:51:08Z by SystemAdmin
SystemAdmin 110000D4XK3105 Posts
Re: How to know the last time a DB2 table has been accessed.2013-01-05T08:51:08ZThis is the accepted answer. This is the accepted answer.by accessed do you mean any access (include reads) or just updates (insert / delete / update) ?
by we need to know - do you need it as a one time thing? a nightly batch? as part of an online process?
which version of db2 are you using?