|
Problem IC75774
|
Status: Closed |
APPLICATION USING TWO PHASE COMMIT (XA) PROTOCOL MAY REPORT SQLCODE -30020 WHEN PURESCALE MEMBERS WENT DOWN |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Application using two phase commit (XA) protocol may report
SQLCODE -30020 0X124C"("011D")"after one of the
pureScale/sysplex member down. If enableWLB ( Transaction
level load balancing) is enabled, and one of member is down, DB2
data server client/driver moves the connections to other
members of pureScale or sysplex data sharing group. Sqlcode
-30108 is returned to application after automatic reroute. If
application continues to send new sql requests instead of
calling rollback, driver can report DRDA syntax error ( or
sqlocode -30020). |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Applications using Pure Scale/direct syspelx support *
****************************************************************
* PROBLEM DESCRIPTION: *
* Application using two phase commit (XA) protocol may report *
* SQLCODE -30020 0X124C"("011D")"after one of the *
* pureScale/sysplex member down. If enableWLB ( Transaction *
* level load balancing) is enabled, and one of member is down, *
* DB2 data server client/driver moves the connections to other *
* members of pureScale or sysplex data sharing group. Sqlcode *
* -30108 is returned to application after automatic reroute. *
* If application continues to send new sql requests instead of *
* calling rollback, driver can report DRDA syntax error ( or *
* sqlocode -30020). *
* *
* The issue was caused because of incorrect error handling of *
* DB2 Client/Driver. *
****************************************************************
* RECOMMENDATION: *
* Upgrade client to v9.7.5. *
**************************************************************** |
| Local Fix: |
Issue rollback if db2 client reports SQLCODE -30108. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Application using two phase commit (XA) protocol may report
SQLCODE -30020 0X124C"("011D")"after one of the
pureScale/sysplex member down. If enableWLB ( Transaction
level load balancing) is enabled, and one of member is down, DB2
data server client/driver moves the connections to other
members of pureScale or sysplex data sharing group. Sqlcode
-30108 is returned to application after automatic reroute. If
application continues to send new sql requests instead of
calling rollback, driver can report DRDA syntax error ( or
sqlocode -30020).
The issue was caused because of incorrect error handling of DB2
Client/Driver. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.04.2011
08.12.2011
08.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
