Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2013-01-05T08:51:08Z by SystemAdmin
SystemAdmin
SystemAdmin
3105 Posts
ACCEPTED ANSWER

Pinned topic How to know the last time a DB2 table has been accessed.

‏2012-10-29T12:42:41Z |
hello
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?

Thank you.
Updated on 2013-01-05T08:51:08Z at 2013-01-05T08:51:08Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    3105 Posts
    ACCEPTED ANSWER

    Re: How to know the last time a DB2 table has been accessed.

    ‏2013-01-05T08:51:08Z  in response to SystemAdmin
    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?