Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2008
    Posts
    3

    Smile Unanswered: Need help - DB2 Table changes

    Scenario: We have DB2 table which get updated on daily basis. we need to extract only data which got changed during updation.

    Is there any way to find out changes to thes table. I understand there is Log that get updated evrytime the table data gets updated. Is there any DB2 utility which can be used to read this log and find/extract out changed information.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Depending on your DB2 version and platform, you may be able to use the last modification timestamp to find the desired rows. See the ROW CHANGE expression: http://publib.boulder.ibm.com/infoce.../r0052407.html
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    you actually have a few choices here. You can do as Mr. Stolze suggested, but a log analysis tool and create reports based on the logs, set up triggers to capture the changes in another table, select from your update. Of course, as was mentioned some of these may depend on which version of DB2 you are using.
    Dave

Posting Permissions

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