home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC67698 Status: Closed

XAER_OUTSIDE, hang or connection leak in JDBC/JCC driver

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
When the JDBC/JCC driver switches between XA (2 phase commit) 
local/global transactions in some cases it may not reuse an 
existing TransportObject.  Instead it creates a new connection 
which results in a connection leakage and you may notice that 
increasing JDBC property maxTransportObject may delay the amount 
of time before the application hangs. 
 
Another possible symptom is XAER_OUTSIDE (Resource Manager doing 
work outside global transaction) or hang when trying to start a 
new XA transaction. 
 
This error applies only when the JDBC/JCC driver is connected to 
DB2 for z/OS using the XA connection.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See ERROR DESCRIPTION.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the JDBC/JCC driver to the one included with v9.1    * 
* Fixpack 10.                                                  * 
****************************************************************
Local Fix:
Set JDBC/JCC property: 
 
queryCloseImplicit=DB2BaseDataSource.QUERY_CLOSE_IMPLICIT_NO (2) 
 
Please note this workaround only resolves the XAER_OUTSIDE 
issue.  It does not resolve the hang or connection leakage 
problem.
Solution
Upgrade the client application to use the JDBC/JCC driver 
included with v9.1 Fixpack 10.
Workaround
N/A
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
09.04.2010
16.06.2011
16.06.2011
Problem solved at the following versions (IBM BugInfos)
9.1.,
9.1.FP10
Problem solved according to the fixlist(s) of the following version(s)