|
Problem IC79397
|
Status: Closed |
SQL30108N ERROR RETURNED - SEAMLESS FAILOVER WITH SCROLLABLE CURSORS AND DB2 FOR Z/OS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 DB2 9.7 FP6 or above *
**************************************************************** |
| Local Fix: |
n/a |
| available fix packs: |
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 |
Problem is first fixed in DB2 9.7 FP6 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84298
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.10.2011
05.06.2012
05.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
