DB2 - Problem description
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) |