|
Problem IC84298
|
Status: Closed |
SQL30108N ERROR RETURNED - SEAMLESS FAILOVER WITH SCROLLABLE CURSORS AND DB2 FOR Z/OS |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 CLI with DB2 for z/OS *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB210.1 FP1 or above *
**************************************************************** |
| Local Fix: |
n/a |
| available fix packs: |
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
|
| Solution |
Problem is first fixed in DB2 10.1 FP1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.06.2012
11.02.2013
11.02.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
