Get transaction information from DB2

[JMaria]

Hi I need to get on daily basis the following information
to determine what updates have been made using SQL insert, update or delete statements? even the information down to the row/field level including the userid that performed the update time and date. Can you point me the best way to get this information!! Thanks!

 

[papadba]

Incorporate a transaction log throughout the application.

Each time an insert/update/delete is done, record the informaton that needs to be tracked.