Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2012
    Posts
    7

    Unanswered: get the list of db2 tables which have been changed since a particular timestamp

    Is there any way in IBM DB2 to get the list of tables which have been changed(updated/added/deleted) since a specific timestamp?

    The problem i am facing is i have restored one backup on 25 July in one box from live db server and updated this restored DB while enabling features packs. Now the live DB server has changed since customer is accessing it and i cannot restore the latest backup as box1 have some addition tables/data.

    So i wanted to know the list of tables which have been changed since last backup so that i can update those tables manually. Please help.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if using v10 - maybe LASTUSED in syscat.tables can be used..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Aug 2012
    Posts
    7
    Thanks Przytula

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by przytula_guy View Post
    if using v10 - maybe LASTUSED in syscat.tables can be used..
    1) this information is not 100% reliable
    2) LASTUSED is also updated on SELECTs, so you'll probably end up with the complete list of your application tables
    ---
    "It does not work" is not a valid problem statement.

Tags for this Thread

Posting Permissions

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