IBM Support

IC74442: ENABLE CODEPAGEOVERRIDE SUPPORT BY DEFAULT FOR INFORMIX SERVER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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
    

Local fix

  • For DB2Client: use db2set DB2CODEPAGE=1208
    For IBM Data Server Provider for .Net: set environment variable
    DB2CODEPAGE=1208
    

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                            *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.7 Fix Pack 5
    

Temporary fix

  • For DB2Client: use db2set DB2CODEPAGE=1208
    For IBM Data Server Provider for .Net: set environment variable
    DB2CODEPAGE=1208
    

Comments

APAR Information

  • APAR number

    IC74442

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-02-14

  • Closed date

    2012-02-15

  • Last modified date

    2012-02-15

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC74444 IC74445

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 February 2012