Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    456

    Unanswered: Audit DDL and DML in LUW DB2

    Is there any built-in tool in DB2 V8 to capture the changes made to data as well as structure. I know there is a tool on MainFrame side to do log mining and looking for something similar on LUW side. Thanks.

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    hi
    what we do is take the structure of all the object through db2look command.
    and then compare the two different files using Text comparator s/w like ExamDiff. also looking for a better soln.

    Thanks
    Rahul

Posting Permissions

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