Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

    Unanswered: read transaction logs

    What tools are you aware of that can be used to read db2 transaction logs?

    The purpose is to capture the info about who (if possible) had done what (DML/DDL), not to recover data. I'm aware of db2audit and db2readlog API. list history can also be used to see DDL changes. What else can be used (free or paid)?

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    adding statement event monitor

  3. #3
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    i am tempted to change my nick on this forum to ZAI4IK or KROLIK
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    why not PETE4KA

  5. #5
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    haha, you got me, Bella...
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  6. #6
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Quote Originally Posted by BELLO4KA View Post
    What tools are you aware of that can be used to read db2 transaction logs?

    The purpose is to capture the info about who (if possible) had done what (DML/DDL), not to recover data. I'm aware of db2audit and db2readlog API. list history can also be used to see DDL changes. What else can be used (free or paid)?
    Not aware of any thing other than that; but I am tempted to do some programming to rollback some bad update. Do you think it is possible ?? (other thread := Any command/tool to un-do the updates on a table ??)


    Regards

Posting Permissions

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