Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC74442 Status: Closed

ENABLE CODEPAGEOVERRIDE SUPPORT BY DEFAULT FOR INFORMIX SERVER

product:
DB2 CONNECT / DB2CONNCT / 970 - DB2
Problem description:
Net applications running against Informix server change        c 
haracters to substitute character 0x1A or report a code-set    c 
onversion error when sending characters between 0x80 and 0x9F  t 
o the database as parameters. 
                                                               T 
he error thrown by the application is: 
                                                               E 
RROR [IX000] [IBM][IDS/UNIX64] Code-set conversion function    f 
ailed due to illegal sequence or invalid value.                S 
QL Error = -23103
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* WINDOWS and DATA SERVER DRIVER                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* .Net applications running against Informix server change     * 
* characters to substitute character 0x1A or report a code-set * 
* conversion error when sending characters between 0x80 and    * 
* 0x9F to the database as parameters.                          * 
*                                                              * 
* The error thrown by the application is:                      * 
*                                                              * 
* ERROR [IX000] [IBM][IDS/UNIX64] Code-set conversion function * 
* failed due to illegal sequence or invalid value.             * 
* SQL Error = -23103                                           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 Fix Pack 5                            * 
****************************************************************
Local Fix:
For DB2Client: use db2set DB2CODEPAGE=1208 
For IBM Data Server Provider for .Net: set environment variable 
DB2CODEPAGE=1208
available fix packs:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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 was first fixed in Version 9.7 Fix Pack 5
Workaround
For DB2Client: use db2set DB2CODEPAGE=1208 
For IBM Data Server Provider for .Net: set environment variable 
DB2CODEPAGE=1208
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC74444 IC74445 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.02.2011
15.02.2012
15.02.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.5 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.