IBM Support

IC80588: 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:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 UDB version 9.1 fixpack 12.                   *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.1 Fix Pack 12.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC80588

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-12-25

  • Closed date

    2012-08-02

  • Last modified date

    2012-08-02

  • 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

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

Document Information

Modified date:
02 August 2012