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. 3 11049
"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
"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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: francis70 |
last post by:
Hi,
I have these 2 problem? Is there a way in Oracle to read UNCOMMITED
data. i.e. in Oracle the normal behaviour is that a user's updates to a
table are visible to other users ONLY when the...
|
by: Avanish Pandey |
last post by:
Hello All
We have 3 differen services (in 3 different server) Service A,B,C . We
want to implement distributed transaction when call methods of B and C
from A. Is it possible? if yes then how?
...
|
by: Holyman |
last post by:
Hi group
I have an application running on a couple of pc's all connecting to
the same SQL-serve databaser. The other day one of my applications
started a transaction which it never committed...
|
by: masri999 |
last post by:
Hello,
I need to monitor every 15 minutes growth in data file and log file .
Since mdf and intial file sizes are set to high value,
measuring these values at 15 min interval will not provide the...
|
by: Andrei Ivanov |
last post by:
Hello,
it seems my postgresql data has somehow become corrupted (by a forced
shutdown I think):
psql template1 -U shadow
Password:
ERROR: nodeRead: did not find '}' at end of plan node...
|
by: hype |
last post by:
Hi,
How can I find out how much space has been used in the log file
and how much of it is free or yet to be used ?
Thanks,
Hype
|
by: John Lee |
last post by:
Hi,
I have few questions related to .NET 2.0 TransactionScope class behavior:
1. Check Transaction.Current.TransactionInformation.DistributedIdentifier to
identify if distributed transaction...
|
by: Sam Durai |
last post by:
Hello, is there is any snapshot element availble which could give the
no of uncommited Insert/Update/Delete stmts there were executed by an
application.
In the app shap I understand that this...
|
by: prakashgrp |
last post by:
Hi,
first i am new to sql server:
server version is sql server 2000
we used to get lot of blocking session and we thought of use isolation level read uncommited instead of read...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |