IBM Support

PH55443: INVALID DATA LOADED IN TO UNICODE COLUMNS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customer is performing LOAD of UNICODE data with CHAR/VARCHAR
    or CLOB columns on MIXED=NO subsystems..
    The data loaded in to the destination table may contain invalid
    data for columns in Unicode with CCSID 1208..
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Optim users performing LOAD of DB2 Unicode   *
    *                 data on MIXED=NO subsystems..                *
    ****************************************************************
    * PROBLEM DESCRIPTION: The data loaded in to the destination   *
    *                      table may contain invalid data for      *
    *                      columns in Unicode with CCSID 1208..    *
    ****************************************************************
    Optim is not generating the required MIXED keyword when creating
    the LOAD statements for Unicode CCSID 1208 columns  on MIXED=NO
    subsystems..
    

Problem conclusion

  • Optim processing will be corrected to produce the correct
    LOAD statements.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH55443

  • Reported component name

    OPTIM MOVE FOR

  • Reported component ID

    5655V0700

  • Reported release

    B70

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-06-27

  • Closed date

    2023-07-20

  • Last modified date

    2023-08-01

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

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

    UI92820

Modules/Macros

  • FOP9APIM FOPCFPMN FOPCXLIB FOPHSTM  FOPMAIN  FOPMAMAI FOPMCOLP
    FOPMDPRC FOPMECMN FOPMMJBS FOPMMUNU FOPMMUTL FOPOMN   FOPZFBMN
    FOPZFMMN
    

Fix information

  • Fixed component name

    OPTIM MOVE FOR

  • Fixed component ID

    5655V0700

Applicable component levels

  • RB70 PSY UI92820

       UP23/07/22 P F307 ¢

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"B70"}]

Document Information

Modified date:
01 August 2023