IBM Support

IC80589: CLPPLUS RETURNED JAVA.IO.CHARCONVERSIONEXCEPTION, IF DATABASE CODE PAGE IS NOT SAME AS LANG ENVIRONMENT VARIABLE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • clpplus may return a java.io.CharConversionException, if
    the database code page is not same as the code page
    implied by the setting of the LANG environment variable
    at the time that DB2 is started.
    
    In the following example, the database is created with
    code page 1208; however, the DB2 server locale of
    Ja_JP implies a Shift JIS code page, not Unicode.  DB2
    formats the value of SQLERRM using Shift JIS, resulting
    in a code page conversion error.
    
    export LANG=Ja_JP
    db2set DB2_COMPATIBILITY_VECTOR=ORA
    db2set DB2COMM=TCPIP
    db2 update dbm cfg using svcename db2test
    db2start
    db2 create db testdb using codeset UTF-8 territory JP
    
    Execute the following pl/sql.
    
    create table TEST ( id NUMBER, name VARCHAR2(10));
    set serveroutput on;
    DECLARE
      v_rec test%ROWTYPE;
    BEGIN
          select * into v_rec from test where id = 100;
    EXCEPTION
      WHEN Others THEN
        DBMS_OUTPUT.PUT_LINE('SQLERRM:'||SQLERRM);
    END;
    /
    drop table TEST;
    quit;
    
    clpplus -nw userid/password@HOSTNAME:PORTNUMBER/DATABASE
    @test.sql
    
    You will see a DB250505E error.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * clpplus may return a java.io.CharConversionException, if     *
    * the database code page is not same as the code page          *
    * implied by the setting of the LANG environment variable      *
    * at the time that DB2 is started.                             *
    *                                                              *
    * In the following example, the database is created with       *
    * code page 1208; however, the DB2 server locale of            *
    * Ja_JP implies a Shift JIS code page, not Unicode.  DB2       *
    * formats the value of SQLERRM using Shift JIS, resulting      *
    * in a code page conversion error.                             *
    *                                                              *
    * export LANG=Ja_JP                                            *
    * db2set DB2_COMPATIBILITY_VECTOR=ORA                          *
    * db2set DB2COMM=TCPIP                                         *
    * db2 update dbm cfg using svcename db2test                    *
    * db2start                                                     *
    * db2 create db testdb using codeset UTF-8 territory JP        *
    *                                                              *
    * Execute the following pl/sql.                                *
    *                                                              *
    * create table TEST ( id NUMBER, name VARCHAR2(10));           *
    * set serveroutput on;                                         *
    * DECLARE                                                      *
    *   v_rec test%ROWTYPE;                                        *
    * BEGIN                                                        *
    *       select * into v_rec from test where id = 100;          *
    * EXCEPTION                                                    *
    *   WHEN Others THEN                                           *
    *     DBMS_OUTPUT.PUT_LINE('SQLERRM:'||SQLERRM);               *
    * END;                                                         *
    * /                                                            *
    * drop table TEST;                                             *
    * quit;                                                        *
    *                                                              *
    * clpplus -nw userid/password@HOSTNAME:PORTNUMBER/DATABASE     *
    * @test.sql                                                    *
    *                                                              *
    * You will see a DB250505E error.                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 UDB version 9.5 fixpack 10.                   *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.5 Fix Pack 10.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC80589

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-12-25

  • Closed date

    2012-10-20

  • Last modified date

    2012-10-20

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

    IC77686

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       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.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 October 2012