PH14461: ARCHIVE OR EXTRACT LOAD FAILS WITH SYSTEM ERROR SORT UNSUCCESSFUL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ErrCB.ID=      ZZZERRCBZZ
  SysRel=        11.7.0
  DB2Rel=        1210(NFM)
  ErrCB.Type=    SYSTEM_ERROR
  ErrCB.AuxInfo= rc=16
  ErrCB.Code=    -1
  ErrCB.U.Msg=   Sort Unsuccessful
  Number of Function Entries=  5
    ErrCB.N(0).Src=     FOPMSORT 20180619 COPYSENT
    ErrCB.N(0).Func=    (000214) SystemSort
    ErrCB.N(1).Src=     FOP9DLMN 20190624 PH12844
    ErrCB.N(1).Func=    (001412) DBL_dynamn
    ErrCB.N(2).Src=     FOPURES2 20190212 PH07856
    ErrCB.N(2).Func=    (002715) DB2LoadStatement
    ErrCB.N(3).Src=     FOPUMAIN 20190419 PH09592
    ErrCB.N(3).Func=    (000850) FOPMMUTL_dynamn
    ErrCB.N(4).Src=     FOPMMAIN 20190419 PH09592
    ErrCB.N(4).Func=    (001032) Main
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Optim for z/OS users of Archive or Extract   *
  *                 LOAD of DB2 tables with a clustering index   *
  *                 and SORT_ROWS YES.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: ErrCB.ID=      ZZZERRCBZZ               *
  *                      SysRel=        11.7.0                   *
  *                      DB2Rel=        1210(NFM)                *
  *                      ErrCB.Type=    SYSTEM_ERROR             *
  *                      ErrCB.AuxInfo= rc=16                    *
  *                      ErrCB.Code=    -1                       *
  *                      ErrCB.U.Msg=   Sort Unsuccessful        *
  *                      Number of Function Entries=  5          *
  *                        ErrCB.N(0).Src=     FOPMSORT 20180619 *
  *                        COPYSENT                              *
  *                        ErrCB.N(0).Func=    (000214)          *
  *                        SystemSort                            *
  *                        ErrCB.N(1).Src=     FOP9DLMN 20190624 *
  *                        PH12844                               *
  *                        ErrCB.N(1).Func=    (001412)          *
  *                        DBL_dynamn                            *
  *                        ErrCB.N(2).Src=     FOPURES2 20190212 *
  *                         PH07856                              *
  *                        ErrCB.N(2).Func=    (002715)          *
  *                        DB2LoadStatement                      *
  *                        ErrCB.N(3).Src=     FOPUMAIN 20190419 *
  *                         PH09592                              *
  *                        ErrCB.N(3).Func=    (000850)          *
  *                        FOPMMUTL_dynamn                       *
  *                        ErrCB.N(4).Src=     FOPMMAIN 20190419 *
  *                         PH09592                              *
  *                        ErrCB.N(4).Func=    (001032) Main     *
  *                                                              *
  *                      Miscellaneous abends can occur due to   *
  *                      storage overlays.                       *
  ****************************************************************
  * RECOMMENDATION: Apply the provided fix.                      *
  ****************************************************************
  When processing multiple tables Optim incorrectly uses the same
  sort record size for all of the tables.
  This may also result in invalid data loaded into DB2 table.
  

Problem conclusion

• Sort record size is provided for each table.
  

Temporary fix

Comments

APAR Information

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

  PH14460

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

Modules/Macros

• FOP0HMNP FOP1OSFN FOP9APIM FOPAM003 FOPAM004 FOPAM005 FOPAR000
  FOPAR001 FOPCFPMN FOPCXLIB FOPD2V85 FOPD2V91 FOPD2VA5 FOPD2VNN
  FOPDC000 FOPE0004 FOPHSTM  FOPK05   FOPK07   FOPK09   FOPMADDE
  FOPMAFCN FOPMAIN  FOPMAMAI FOPMCBMN FOPMCMAI FOPMCMMN FOPMCOLA
  FOPMCOLP FOPMDBMN FOPMDPRC FOPMDXTR FOPMECMN FOPMEMAI FOPMMCMR
  FOPMMJBS FOPMMUNU FOPMMUTL FOPMUXIM FOPODPP  FOPOMN   FOPRM000
  FOPRS2   FOPRS3   FOPRS4   FOPRS7   FOPRS9   FOPT100G FOPT59H
  FOPTAC67 FOPTDS11 FOPUMCBT FOPXM001 FOPXMC01 FOPXMD01 FOPZFMMN
  FOPZMAIN FOPZSUB
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI64303

     UP19/07/20 P F907 ¢

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.