470,636 Members | 1,526 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,636 developers. It's quick & easy.

Uncommitted statements?

Hi,

is there any commandline option to see if there are uncommitted
statements and which statements aren't comitted? Or at least a hint that
there are uncommitted pages in the transaction log.

Bernd
May 18 '06 #1
2 1927
The db2 get snapshot for database on dbname will give you.
The log file name of the first active log, which should contain either or
both of 1 or more transaction in flight or dirty (committed but not
externalized to the table).
The last active log file.
The application handle of the appl. holding the pldest in flight
transaction.
But not the contents of the logs, nor the number of transactions in those
states.

A snapshot at the application level will show you how many appls. there are,
which are holding what type of locks and how many locks are held. You could
also turn the statement switch on to get this at the statement lervel. This
could be a busy report!!!!!
Those holding locks would be the ones that have not rolled back or committed
and therefore have in flight stuff.

HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Bernd Hohmann" <ho*****@harddiskcafe.de> a écrit dans le message de news:
4d*************@individual.net...
Hi,

is there any commandline option to see if there are uncommitted statements
and which statements aren't comitted? Or at least a hint that there are
uncommitted pages in the transaction log.

Bernd


May 18 '06 #2
Once you identify the LOG file which u want to read you can use
SQLURLOG API
to read its contents.

cheers...
Shashi Mannepalli

May 18 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Pham Nguyen | last post: by
3 posts views Thread by Steve Atkins | last post: by
1 post views Thread by Karl | last post: by
2 posts views Thread by ojorus | last post: by
7 posts views Thread by Igor | last post: by
reply views Thread by Ohad Frand | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.