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.logF atal(LogSer
vice (?:?) - JavaException: Error 11070 Collaboration exception at
step 3 in VBJ
ThreadPool Wo************* *******@692a400 4C...6954 c004.mai
n:, Error 11070 Java exception
encountered:COM .ibm.db2.jdbc.D B2Exception: [IBM][
CLI Driver][DB2/6000] SQL0964C The transaction log for the database
is full. S
QLSTATE=57011
at COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.th row_SQLExceptio n(SQLExce
ptionGenerator. java(Compiled Code))
at COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.th row_SQLExceptio n(SQLExce
ptionGenerator. java(Inlined Compiled Code))
at COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.ch eck_return_code (SQLExcep
tionGenerator.j ava(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 11087
"Daniel Chou" <dn*****@yahoo. com> wrote in message
news:bc******** *************** ***@posting.goo gle.com... 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.logF atal(LogSer vice (?:?) - JavaException: Error 11070 Collaboration exception at step 3 in VBJ ThreadPool
Wo************* *******@692a400 4C...6954 c004.mai n:, Error 11070 Java exception encountered:COM .ibm.db2.jdbc.D B2Exception: [IBM][ CLI Driver][DB2/6000] SQL0964C The transaction log for the database is full. S QLSTATE=57011
at
COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.th row_SQLExceptio n(SQLExce ptionGenerator. java(Compiled Code)) at
COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.th row_SQLExceptio n(SQLExce ptionGenerator. java(Inlined Compiled Code)) at
COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.ch eck_return_code (SQLExcep tionGenerator.j ava(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******* *************@t wister01.bloor. is.net.cable.ro gers.com>... "Daniel Chou" <dn*****@yahoo. com> wrote in message news:bc******** *************** ***@posting.goo gle.com... 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.logF atal(LogSer vice (?:?) - JavaException: Error 11070 Collaboration exception at step 3 in VBJ ThreadPool Wo************* *******@692a400 4C...6954 c004.mai n:, Error 11070 Java exception encountered:COM .ibm.db2.jdbc.D B2Exception: [IBM][ CLI Driver][DB2/6000] SQL0964C The transaction log for the database is full. S QLSTATE=57011
at COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.th row_SQLExceptio n(SQLExce ptionGenerator. java(Compiled Code)) at COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.th row_SQLExceptio n(SQLExce ptionGenerator. java(Inlined Compiled Code)) at COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.ch eck_return_code (SQLExcep tionGenerator.j ava(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************ *************@p osting.google.c om>, 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 user commits. But in
Informix there is this thing called ISOLATION LEVELS. For example by
setting the ISOLATION LEVEL to DIRTY READ, a user will read dirty data,
i.e. the last uncommited updated value of a field by some other user. Is
|
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?
I have read the doc regarding this:
http://www.developer.com/net/asp/article.php/3385631
but it will not work when methods are in different services on
|
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 (programming error) .
The application continiued running for a couple og hours filling every
insert and update statement to the sql-server log-file, where they
remain rigt now. The applications on all the other machines
deadlocket because they...
|
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 change
in size .
My intention is to measure the log file size growth which helps to
calculate the disk space and bandwidth required to setup log shipping .
We need to set up this infrastructure based on this calculation
|
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
Welcome to psql 7.3.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
| |
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 is used - is it accurate way?
2. I have the following code blocks -
In code block 1, the first check the DistributedIdentifier is ALL 0s so it
|
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 element "Update/Insert/Delete
statements executed" would give the list of Up/In/Del that have been
executed after the connection has established.
Thanks,
Sam.
|
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 commited(default behaviour)
could any body advise me to set this parameter in database level
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |