DB2 FOR LUW / DB2FORLUW / 970 - DB2

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).

**************************************************************** 
* 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.                                    * 
****************************************************************

Issue rollback if db2 client reports SQLCODE -30108.

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
 

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.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

13.04.2011
08.12.2011
08.12.2011

9.7.5