A fix is available
APAR status
Closed as program error.
Error description
MiscCCSIDInfo failed for CCSID 0 DB2Rel=1115(NFM), Rel=11.7.0 Code=-1, AuxInfo= 01 FOPXINIT 20180619 COPYSENT (001512) GetTblColList 02 FOPXINIT 20180619 COPYSENT (000805) DXValidateAD 03 FOPXMAIN 20180619 COPYSENT (001581) DXDataExplain 04 FOPJPER 20180619 COPYSENT (004868) ChkAD 05 FOPJPER 20180619 COPYSENT (002139) PerformExtract 06 FOPJEXT 20180619 COPYSENT (001574) ProcessExtCmds 07 FOPJEXT 20180619 COPYSENT (000590) SetUpExtract
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Optim for z/OS TDM and Archive users of DB2 * * tables created before column CCSID support * * was implemented. * **************************************************************** * PROBLEM DESCRIPTION: MiscCCSIDInfo failed for CCSID 0 * **************************************************************** * RECOMMENDATION: Apply the provided fix. * **************************************************************** MiscCCSIDInfo failed for CCSID 0 DB2Rel=1115(NFM), Rel=11.7.0 Code=-1, AuxInfo= 01 FOPXINIT 20180619 COPYSENT (001512) GetTblColList 02 FOPXINIT 20180619 COPYSENT (000805) DXValidateAD 03 FOPXMAIN 20180619 COPYSENT (001581) DXDataExplain 04 FOPJPER 20180619 COPYSENT (004868) ChkAD 05 FOPJPER 20180619 COPYSENT (002139) PerformExtract 06 FOPJEXT 20180619 COPYSENT (001574) ProcessExtCmds 07 FOPJEXT 20180619 COPYSENT (000590) SetUpExtract Optim is processing a table created in an earlier version of DB2 that did not support column CCSID metadata. The column is defined with a CCSID of 0 and Optim fails while attempting to determine the CCSID attributes
Problem conclusion
Optim has been modified to detect the CCSID 0 value and assert a CCSID value depending upon column type, subtype and the table ENCODING_SCHEME.
Temporary fix
Comments
APAR Information
APAR number
PH05018
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
2018-11-07
Closed date
2018-12-20
Last modified date
2019-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
FOP00003 FOP00103 FOP00203 FOP00303 FOP00B FOP01B FOP05B FOP07B FOP08B FOP09B FOP0AB FOP0BB FOP0ITKA FOP1ODRV FOP1OSFN FOP3DTPR FOP4IPMN FOP4PEMN FOP4PMMN FOP4TRCE FOP9APIM FOP9GINF FOPCFPMN FOPCXLIB FOPD2V85 FOPD2V91 FOPD2VA5 FOPD2VNN FOPHSTM FOPIO FOPK03 FOPK05 FOPK10 FOPLUAH FOPMADDE FOPMAFCN FOPMAIN FOPMAMAI FOPMARCN FOPMCBMN FOPMCDRT FOPMCENU FOPMCMAI FOPMCMMN FOPMCOFN FOPMCOLA FOPMCOLP FOPMDBMN FOPMDDDL FOPMDMAI FOPMDPRC FOPMDXTR FOPMECMN FOPMEMAI FOPMIXMM FOPMMCMN FOPMMCMR FOPMMJBS FOPMMUNU FOPMMUTL FOPMSELM FOPMTMDB FOPMUXIM FOPODPP FOPOMN FOPRS10 FOPRS8 FOPRS9 FOPUMCBT FOPUUNLD FOPVOU FOPZFBMN FOPZFMMN FOPZMAIN FOPZSUB
Fix information
Fixed component name
OPTIM MOVE FOR
Fixed component ID
5655V0700
Applicable component levels
RB70 PSY UI60408
UP18/12/22 P F812
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","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 January 2019