|
Problem IT41198
|
Status: Closed |
JCC DRIVER RETURNS -204 DUE TO IMPROPER SCHEMA ORDER REPLAY WHENUSING SYSPLEX WLB
|
| product: |
DB2 CONNECT / DB2CONNCT / B50 - DB2 |
| Problem description: |
In a WLB environment, JCC driver switches the member and while
acquiring a new member, it replays the old special registers
that are set on the connection.
When replaying the special registers, jcc driver may hit
SqlSyntaxErrorException due to incorrect sequence of registers
in the replay and it may send a wrong Special register to server
causing a syntax error.
under a heavy load sysplex WLB environment, this issue surfaces
due to a invalid schema register REPLAY. This issue is also
associated with a server APAR PH46547. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 JCC Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to 11.5.8.0 or higher *
**************************************************************** |
| Local Fix: |
Disable WLB |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* DB2 JCC Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to 11.5.8.0 or higher *
**************************************************************** |
| Comment |
upgrade to JCC 11.5.8.0 with the Db2 server APAR PH46547 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.06.2022
07.10.2022
24.10.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
