read transaction logs

db2girl · #1 (**permalink**) 01-07-11, 09:21

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)?

db2girl · #2 (**permalink**) 01-07-11, 10:26

adding statement event monitor

MarkhamDBA · #3 (**permalink**) 01-13-11, 11:22

i am tempted to change my nick on this forum to ZAI4IK or KROLIK

db2girl · #4 (**permalink**) 01-13-11, 18:41

why not PETE4KA

MarkhamDBA · #5 (**permalink**) 01-13-11, 20:12

haha, you got me, Bella...

DBFinder · #6 (**permalink**) 01-13-11, 21:08

Quote:

Originally Posted by BELLO4KA

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

Internet Services

Web Development

Digital Marketing

Consumer Tech