DB2 FOR LUW / DB2FORLUW / A10 - 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 DB210.1 FP1 or above                              * 
****************************************************************

n/a

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem is first fixed in DB2 10.1 FP1

keiner bekannt / siehe Local-Fix

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

13.06.2012
11.02.2013
11.02.2013