Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009

    Unanswered: Last database update time

    Database Version: DB2 V9.5 on AIX
    Single partitioned environment

    Is there any way to determine when was the database last updated ? Meaning when was any table[other than system tables] was last updated ?

    My task is to determine if the database has been used by the application from the past months? How do we accomplish this task ?

    Any help on this task will be appreciated.

  2. #2
    Join Date
    May 2003
    If you do a snapshot on database, you will see counter such as:
    • Rows inserted
    • Rows updated
    • Rows deleted
    • etc

    These are cumulative since the last time the database was activated.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2009
    Thanks Mark. If I don't have the information collected for Rows inserted/updated/deleted for the past three I wouldn't know the difference.
    Is there any other way I can determine if any rows were written from the last three months without having the data for rows inserted/updated/deleted?

  4. #4
    Join Date
    Jun 2013
    check if any of the tables have a timestamp for inserts
    Last edited by kedrex; 06-05-13 at 13:45.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts