IBM Support

JR35675: DB2 CONNECTOR STAGE METHOD BULK LOAD WITH LOB OR XML COLUMNS=NO LOAD TO IBM-943 DB LOADS SOME CONTROL CHARS INCORRECTLY.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customer has DB2 Database created with codepage IBM-943, using
    DB2 connector with method bulk load (lob or xml columns set to
    NO) loads the character char(26), char(28) and char(127)
    incorrectly.
    
    These should load as their identiy values 0x1A, 0x1C and 0x7F
    however they load as UTF-8 mappings for these characters as
    0x7F, 0x1A, 0x1C.
    

Local fix

  • Use insert method.
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    DB2 Connector
    ****************************************************************
    PROBLEM DESCRIPTION:
    DB2 database codepage is IBM-943 some control characters load
    incorrectly.
    0x1A loads as 0x7F
    0x1C loads as 0x1A
    0x7F loads as 0x1C
    ****************************************************************
    RECOMMENDATION:
    Apply the patch for JR35675.
    ****************************************************************
    

Problem conclusion

  • The problem was that DB2 connector was passing in the incorrect
    codepage to LOAD utility.
    If we are using Japanese environment, we should pass the
    codepage as 943, since input data is generated in 943 codepage.
    But it was overridden by 1208.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR35675

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-02-25

  • Closed date

    2010-03-03

  • Last modified date

    2010-03-03

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

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

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R810 PSN

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 March 2010