Need to trace insert, update, delete on tables (highly critical DB2 db). My questions are:
- how and where the history of inserts, updates, deletes on a table recorded?
- where else but in log files they are recorded?
- how to access those records?

I found an API called 'db2ReadLog' which does it but can not figure out how to run it from CLP. Please help

Read about the DB2 audit facility

An easier way would be to define triggers on the table which will capture the insert / delete / update requests in a separate table which can then be easily analyzed.... as per convenience

As for the logs, the data is ordered in the sequence in which the transactions are carried out and hence even if you were able to extract the data formatting the same for each table would be a real pain ......

Comparing both the scenarios, there will be a little overhead in triggers but then you have to consider the trade-off between ease of use and overhead.... Also you'll have to note the I / U / D frequency to get a better picture.

thx Nick, audit facility looks like a good way to do it but these 3 (insert, update, delete) are not 'auditable events'.

http://publib.boulder.ibm.com/infoce...db.doc/toc.xml

Any other thoughts besides audit or triggers?

They are in DB2 9.5, to which you are planning to migrate. In v. 8 I guess you are stuck with triggers.

Nick, I can not find them on the list in 9.5 either? Am I looking at the right place:

http://publib.boulder.ibm.com/infoce.../r0053355.html

.......................