|
Problem IC95736
|
Status: Closed |
XA_COMMIT() RETURNED XAER_RMFAIL(-7) WITH PURESCALE ENVIRONMENT DURING XA TRANSACTION RECOVERY, WHEN USING AFFINITIES. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
This problem can only happen when using affinities.
When CICSAS process with an active connection to DB2 purescale
member is killed abruptly after it does an xa_prepare and before
it does an xa_commit also the entire TXSeries region (TM) is
brought down forcibly.
During region restart, CICSAS attempts to performs a recovery by
doing a xa_open again and xa_recover and re-prepare the pending
logical unit of works to do COMMIT.
However, the DB2 commit(xa_commit) failed(XAER_RMFAIL) resulting
in TXSeries process hang. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to DB2 UDB version 10.5 fixpack 3. *
**************************************************************** |
| Local Fix: |
switch to WLB(Work Load Balancing) instead of affinities. |
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 UDB Version 10.5 Fixpack 3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.09.2013
03.03.2014
03.03.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
