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

How to find out uncommited transaction?

P: n/a
Hello,

We are running java applications which uses DB2 as the data store.
But sometimes we get the following exception:

2004-04-25 22:51:39,478 FATAL [VBJ ThreadPool Worker]
LogService.logFatal(LogSer
vice (?:?) - JavaException: Error 11070 Collaboration exception at
step 3 in VBJ
ThreadPool Wo********************@692a4004CxCom...t@6954c004.mai
n:, Error 11070 Java exception
encountered:COM.ibm.db2.jdbc.DB2Exception: [IBM][
CLI Driver][DB2/6000] SQL0964C The transaction log for the database
is full. S
QLSTATE=57011

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExce
ptionGenerator.java(Compiled Code))
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExce
ptionGenerator.java(Inlined Compiled Code))
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(SQLExcep
tionGenerator.java(Compiled Code))

It seems that the problem is caused by some uncommitted transactions.
For DB2, how to find out which SQL command is not committed? Thanks a
lot.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"Daniel Chou" <dn*****@yahoo.com> wrote in message
news:bc**************************@posting.google.c om...
Hello,

We are running java applications which uses DB2 as the data store.
But sometimes we get the following exception:

2004-04-25 22:51:39,478 FATAL [VBJ ThreadPool Worker]
LogService.logFatal(LogSer
vice (?:?) - JavaException: Error 11070 Collaboration exception at
step 3 in VBJ
ThreadPool Wo********************@692a4004CxCom...t@6954c004.mai n:, Error 11070 Java exception
encountered:COM.ibm.db2.jdbc.DB2Exception: [IBM][
CLI Driver][DB2/6000] SQL0964C The transaction log for the database
is full. S
QLSTATE=57011

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExce ptionGenerator.java(Compiled Code))
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExce ptionGenerator.java(Inlined Compiled Code))
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(SQLExcep tionGenerator.java(Compiled Code))

It seems that the problem is caused by some uncommitted transactions.
For DB2, how to find out which SQL command is not committed? Thanks a
lot.


db2 list applications show detail

This will show you each connected application, and it's state. You can then
map this back to determine which application hasn't committed in a long
time.

Matt Emmerton
Nov 12 '05 #2

P: n/a
"Matt Emmerton" <me******@yahoo.com> wrote in message news:<mA********************@twister01.bloor.is.ne t.cable.rogers.com>...
"Daniel Chou" <dn*****@yahoo.com> wrote in message
news:bc**************************@posting.google.c om...
Hello,

We are running java applications which uses DB2 as the data store.
But sometimes we get the following exception:

2004-04-25 22:51:39,478 FATAL [VBJ ThreadPool Worker]
LogService.logFatal(LogSer
vice (?:?) - JavaException: Error 11070 Collaboration exception at
step 3 in VBJ
ThreadPool

Wo********************@692a4004CxCom...t@6954c004.mai
n:, Error 11070 Java exception
encountered:COM.ibm.db2.jdbc.DB2Exception: [IBM][
CLI Driver][DB2/6000] SQL0964C The transaction log for the database
is full. S
QLSTATE=57011

at

COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExce
ptionGenerator.java(Compiled Code))
at

COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExce
ptionGenerator.java(Inlined Compiled Code))
at

COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(SQLExcep
tionGenerator.java(Compiled Code))

It seems that the problem is caused by some uncommitted transactions.
For DB2, how to find out which SQL command is not committed? Thanks a
lot.


db2 list applications show detail

This will show you each connected application, and it's state. You can then
map this back to determine which application hasn't committed in a long
time.

Matt Emmerton


But for java, "db2 list applications show detail" shows only java.exe,
how to know which SQL command is left uncommited for a long time?
Thanks a lot.
Nov 12 '05 #3

P: n/a
In article <bc*************************@posting.google.com> , Daniel
Chou (dn*****@yahoo.com) says...

But for java, "db2 list applications show detail" shows only java.exe,
how to know which SQL command is left uncommited for a long time?
Thanks a lot.


The 'get snapshot for application' command will give you a lot of
info about it.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.