PH03556: SYSTEM ERROR ARCHIVING/EXTRACTING FROM NON-EBCDIC DB2 TABLE CONTAINING DATE/TIME COLUMNS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• IBM InfoSphere Optim System Error Structure - ErrCB
  ErrCB.ID=      ZZZERRCBZZ
  SysRel=        11.7.0
  DB2Rel=        1115(NFM)
  ErrCB.Type=    SYSTEM_ERROR
  ErrCB.AuxInfo=
  ErrCB.Code=    -1
  ErrCB.U.Msg=   Invalid handle
  Number of Function Entries=  6
    ErrCB.N(0).Src=     FOPSMHEP 20180912 R373203D
    ErrCB.N(0).Func=    (000431) MemHeapAllocEntry
    ErrCB.N(1).Src=     FOP9XFBM 20180912 R373203D
    ErrCB.N(1).Func=    (000805) XFBOpen
    ErrCB.N(2).Src=     FOPXMAIN 20180619 COPYSEND
    ErrCB.N(2).Func=    (001075) DXDataExtract
    ErrCB.N(3).Src=     FOPUCRE  20180912 R373203D
    ErrCB.N(3).Func=    (000766) CreateStatement
    ErrCB.N(4).Src=     FOPUMAIN 20180912 R373203D
    ErrCB.N(4).Func=    (000838) FOPMMUTL_dynamn
    ErrCB.N(5).Src=     FOPMMAIN 20180619 COPYSEND
    ErrCB.N(5).Func=    (001024) Main
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Optim for z/OS users of archive or extract   *
  *                 with non-EBCDIC tables containing date/time/ *
  *                 timestamp columns.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: IBM InfoSphere Optim System Error       *
  *                      Structure - ErrCB                       *
  *                      ErrCB.ID=      ZZZERRCBZZ               *
  *                      SysRel=        11.7.0                   *
  *                      DB2Rel=        1115(NFM)                *
  *                      ErrCB.Type=    SYSTEM_ERROR             *
  *                      ErrCB.AuxInfo=                          *
  *                      ErrCB.Code=    -1                       *
  *                      ErrCB.U.Msg=   Invalid handle           *
  *                      Number of Function Entries=  6          *
  *                        ErrCB.N(0).Src=     FOPSMHEP 20180912 *
  *                       R373203D                               *
  *                        ErrCB.N(0).Func=    (000431)          *
  *                        MemHeapAllocEntry                     *
  ****************************************************************
  IBM InfoSphere Optim System Error Structure - ErrCB
  ErrCB.ID=      ZZZERRCBZZ
  SysRel=        11.7.0
  DB2Rel=        1115(NFM)
  ErrCB.Type=    SYSTEM_ERROR
  ErrCB.AuxInfo=
  ErrCB.Code=    -1
  ErrCB.U.Msg=   Invalid handle
  Number of Function Entries=  6
    ErrCB.N(0).Src=     FOPSMHEP 20180912 R373203D
    ErrCB.N(0).Func=    (000431) MemHeapAllocEntry
    ErrCB.N(1).Src=     FOP9XFBM 20180912 R373203D
    ErrCB.N(1).Func=    (000805) XFBOpen
    ErrCB.N(2).Src=     FOPXMAIN 20180619 COPYSEND
    ErrCB.N(2).Func=    (001075) DXDataExtract
    ErrCB.N(3).Src=     FOPUCRE  20180912 R373203D
    ErrCB.N(3).Func=    (000766) CreateStatement
    ErrCB.N(4).Src=     FOPUMAIN 20180912 R373203D
    ErrCB.N(4).Func=    (000838) FOPMMUTL_dynamn
    ErrCB.N(5).Src=     FOPMMAIN 20180619 COPYSEND
    ErrCB.N(5).Func=    (001024) Main
  
  
  Optim is preparing to process the rows and attempts to allocate
  storage from an uninitialized heap.
  

Problem conclusion

• Code changed to use initialized heap.
  

Temporary fix

Comments

APAR Information

• 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 FOPHSTM  FOPIO    FOPMADDE FOPMAFCN
  FOPMAIN  FOPMAMAI FOPMARCN 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
  FOPRS3   FOPUMCBT FOPUUNLD FOPVOU   FOPZFBMN FOPZFMMN FOPZMAIN
  FOPZSUB
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI59230

     UP18/10/23 P F810

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.