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 IT37644 Status: Closed

DURING XA TRANSACTION, WHEN XAER_RMFAIL IS RECEIVED FROM SERVER,SUCH
CONNECTIONS ARE NOT ISOLATED, CLOSED AND REMOVED FROM CONN

product:
DB2 CONNECT / DB2CONNCT / B50 - DB2
Problem description:
During XA Transaction, when XAER_RMFAIL is received from server,
such connections are not isolated, closed and removed from
connection pool.

for XAConnections, server might return XAER_RMFAIL for certain
transaction processing that are piggy backed. xa.start() and
xa.end() can be seen piggy backed with next xa operation
(prepare/commit/rollback) and server might return XAER_RMFAIL
for the xa.start() or xa.end() is the chained execution
response. If this occurs, then such connection need to be closed
by application.
In order to facilitate application to close such connection, JCC
driver will raise ConnectionEvent according to
ConnectionEventListener interface specification.
Application need to implement such Connection event listener
interface to receive XAER_RMFAIL event.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL Db2 Connect users                                        *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to JCC driver on Db2 version V11.5.7.0               *
****************************************************************
Local Fix:
set xaNetworkOptimization=false
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* ALL Db2 Connect users                                        *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to JCC driver on Db2 version V11.5.7.0               *
****************************************************************
Comment
Fixed in Db2 V11.5.7.0 and later
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.07.2021
03.09.2021
03.09.2021
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)