DB2 FOR LUW / DB2FORLUW / 970 - DB2

When scrollable cursors are used against DB2 for z/OS, deferred 
prepare is disabled even if you have enabled it. 
In this case, two requests are sent to the DB2 for z/OS, one for 
the prepare statement and another one for the execute statement 
: the prepare statement is considered as the first SQL statement 
and the execute as the second SQL statement. If the connection 
between your application and the DB2 for z/OS is lost during the 
execute statement, the seamless failover won't be triggered and 
error SQL30108N will be returned by the application because the 
following condition won't be true anymore. 
 
One condition for the seamless failover to occur for direct 
connections to DB2 for z/OS is 
- The connection is not in a transaction. That is, the failure 
occurs when the first SQL statement in the transaction is 
executed

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 CLI with DB2 for z/OS                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FP6 or above                              * 
****************************************************************

n/a

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
 

Problem is first fixed in DB2 9.7 FP6

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84298 
Nachfolger : 

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

24.10.2011
05.06.2012
05.06.2012

9.7.FP6