Solved

How to find DB2 committed transaction log timestamps?

Posted on 2011-02-23
4
1,969 Views
Last Modified: 2012-05-11
Is there any command to find out the committed transactions in DB2?
0
Comment
Question by:Sudarshan3677
4 Comments
 
LVL 45

Assisted Solution

by:Kent Olsen
Kent Olsen earned 250 total points
ID: 34967180
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).

Kent
0
 
LVL 12

Accepted Solution

by:
mwochnick earned 250 total points
ID: 34967203
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.  http://it.toolbox.com/blogs/db2admin/reading-transaction-logs-26229
here are some articles from IBM
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.apdv.api.doc/doc/r0001910.html
and
an example
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.apdv.api.doc/doc/r0001673.html
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 35196754
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.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question