DB2 - Problem description
Problem IT07300 | Status: Closed |
APPLICATION MAY GET SQL1224 WITH UNICODE CLIENT IF SERVER IS DB2 FOR ZOS AND DCS PARAMETER IS SET | |
product: | |
DB2 CONNECT / DB2CONNCT / A50 - DB2 | |
Problem description: | |
When DB2 registry variable DB2BIDI=YES and DCS directory is BIDI parameter is set with single byte codepage for example CCISID410, DB2 Connect client performs layout transform on the input data, including the quoted strings in SQL statements before sending data to a DB2 for zOS database. If client is a unicode client or using any multibyte BIDI codepage and if there are quoted strings in SQL statement because of this defect DB2 client send incorrect SQL satement length. DB2 for zOS returns an error because of incorrect SQL satement length in the request. Client reports sqlcode SQL1224. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 and Fix Pack 7 * **************************************************************** | |
Local Fix: | |
Solution | |
Problem was first fixed in DB2 Version 10.5 and Fix Pack 7 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.02.2015 20.01.2016 20.01.2016 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.7 |