IBM Support

PH41218: MISCCCSIDINFO FAILED FOR CCSID 0

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customer is attempting to process (EXTRACT/ARCHIVE) a DB2 table.
    Such table has been created on DB2 release prior to V8 and later
    altered to add a GRAPHIC Unicode UTF-16 column. The DB2
    subsystem has been defined with MIXED=NO.
    Optim is reporting the following SystemError:
    
    IBM InfoSphere Optim System Error Structure - ErrCB
    ErrCB.ID=      ZZZERRCBZZ
    SysRel=        11.7.0
    DB2Rel=        1215(NFM)
    ErrCB.Type=    SYSTEM_ERROR
    ErrCB.AuxInfo=
    ErrCB.Code=    -1
    ErrCB.U.Msg=   MiscCCSIDInfo failed for CCSID 0
    Number of Function Entries=  6
      ErrCB.N(0).Src=     FOPXINIT 20210211 PH31236
      ErrCB.N(0).Func=    (001537) GetTblColList
      ErrCB.N(1).Src=     FOPXINIT 20210211 PH31236
      ErrCB.N(1).Func=    (000830) DXValidateAD
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Optim users processing DB2 tables created    *
    *                 prior to DB2 release V8.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: Optim may issue a System Error and      *
    *                      abort processing.                       *
    ****************************************************************
    Optim is incorrectly processing lacking CCSID information and
    being Unicode-encoded.
    

Problem conclusion

  • Optim processing logic will be corrected.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH41218

  • Reported component name

    OPTIM MOVE FOR

  • Reported component ID

    5655V0700

  • Reported release

    B70

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-10-09

  • Closed date

    2021-10-29

  • Last modified date

    2021-12-01

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

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

    UI77861

Modules/Macros

  • FOP9APIM FOPCFPMN FOPCXLIB FOPD2    FOPHSTM  FOPINS0  FOPINS2
    FOPMAIN  FOPMCMAI FOPMCOLA FOPMCOLP FOPMDMAI FOPMDPRC FOPMECMN
    FOPMMCMR FOPMMJBS FOPMMUTL FOPMUXIM FOPOMN   FOPRS10  FOPRS6
    FOPRS9   FOPZFMMN
    

Fix information

  • Fixed component name

    OPTIM MOVE FOR

  • Fixed component ID

    5655V0700

Applicable component levels

  • RB70 PSY UI77861

       UP21/11/02 P F111

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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"B70"}]

Document Information

Modified date:
02 December 2021