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 2003
    Posts
    4,292
    Provided Answers: 5
    Using the DB2 logs to figure this out is not a good idea. You best solution is to add a timestamp column to the table, and user a before trigger to supply the data for this column. Then all you have to do is query the table based on this column. Do not forget to put an index on the column.

    Andy

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Please see the other thread you started. Have a look at the ROW CHANGE clause.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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