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)