I have DB2 UDB v8.2 installed on Windows XP. I am looking for a way to read SQL transactions from the log files (specifically Inserts, Updates and Deletes). I would like to get information like table, fields modified, user, etc.
To give a better idea, I'm looking for something like LogMiner that's available for Oracle. Even something like SQL Profiler (SQL Server) would do. I want to know if there's anything I can do without using third-party software.
I tried the Activity Monitor but it did not display Inserts, updates, etc that I would do from the Command Editor (Java console), and so did not serve my purpose. I also searched extensively on the net but haven't found anything concrete.
Hopefully someone out there would help me out! Thanks.