By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,301 Members | 1,752 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,301 IT Pros & Developers. It's quick & easy.

Basic DB2 transaction diagnosis question

P: n/a

Hi, and thanks in advance... I have about zero experience with DB2, and I
need help diagnosing a transaction-related problem...
What SQL can I run to find what transactions (XA) may be in process
in the DBMS, and which(or how many) dynamic sections may be associated
with a given open transaction? The problem presents itself as a client (complex
middleware) that uses a JDBC driver to do work with DB2. This client runs out
of a clientside jdbc driver resource that is supposed to be released when the
client-involved transaction is ended (either by rollback or commit). I want to
verify whether all the transactions that the client instigated were in fact
completed.

Thanks,
Joe Weinstein at BEA

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
In 8.2 there is a great utility called dbxamon that will monitor and
roolback any XA transactions for you.

"Joe Weinstein" <jo*******@bea.com> wrote in message
news:41********@news.beasys.com...

Hi, and thanks in advance... I have about zero experience with DB2, and I
need help diagnosing a transaction-related problem...
What SQL can I run to find what transactions (XA) may be in process
in the DBMS, and which(or how many) dynamic sections may be associated
with a given open transaction? The problem presents itself as a client (complex middleware) that uses a JDBC driver to do work with DB2. This client runs out of a clientside jdbc driver resource that is supposed to be released when the client-involved transaction is ended (either by rollback or commit). I want to verify whether all the transactions that the client instigated were in fact completed.

Thanks,
Joe Weinstein at BEA

Nov 12 '05 #2

P: n/a
Joe Weinstein <jo*******@bea.com> wrote in message news:<41********@news.beasys.com>...
Hi, and thanks in advance... I have about zero experience with DB2, and I
need help diagnosing a transaction-related problem...
What SQL can I run to find what transactions (XA) may be in process
in the DBMS, and which(or how many) dynamic sections may be associated
with a given open transaction? The problem presents itself as a client (complex
middleware) that uses a JDBC driver to do work with DB2. This client runs out
of a clientside jdbc driver resource that is supposed to be released when the
client-involved transaction is ended (either by rollback or commit). I want to
verify whether all the transactions that the client instigated were in fact
completed.

Thanks,
Joe Weinstein at BEA


try to create event monitor, then y can get all the transaction
currently running. There are lots...
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.