How to find DB2 committed transaction log timestamps?

Is there any command to find out the committed transactions in DB2?
Who is Participating?
mwochnickConnect With a Mentor Commented:
The committed transactions are in the transaction logs.  Unfortunately these are binary and require a tool to read them.  DB Recovery Expert is one such tool.  A second approach is to build your own tool using the DB2 api.  I've never tried this, but here is an article that talks about that approach.
here are some articles from IBM
an example
Kent OlsenConnect With a Mentor Data Warehouse Architect / DBACommented:
Hi Sudarshan,

It will vary depending on which version of DB2 you're running, but you'll have to extract that information from the logs.  I'm unaware of a command to do so, but the db2ReadLog API can be called from a user-written program to scan the log file(s).

Guy Hengel [angelIII / a3]Billing EngineerCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.