PI17195: SELECTIVE RESTORE ENDS WITH INTERNAL SYSTEM ERROR: INVALID TYPE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The client is performing SELECTIVE RESTORE of multiple tables
  from an ARCHIVE file and receiving the following Optim system
  error:
  IBM InfoSphere Optim System Error Structure - ErrCB
  ErrCB.ID=      ZZZERRCBZZ
  SysRel=        7.2.0
  DB2Rel=        1015(NFM)
  ErrCB.Type=    Invalid Type
  ErrCB.AuxInfo=
  ErrCB.Code=    0
  ErrCB.U.Buffer(Msg or SQLCA)=
  Number of Function Entries=  13
    ErrCB.N(0).Src=     FOPXARSL 20140128 UI14507D
    ErrCB.N(0).Func=    (001812) OpenCursor
    ErrCB.N(1).Src=     FOPXARSL 20140128 UI14507D
    ErrCB.N(1).Func=    (001544) GetSelectStrategy
    ErrCB.N(2).Src=     FOPXARSL 20140128 UI14507D
    ErrCB.N(2).Func=    (000948) GetRowsFromArcFile
    ErrCB.N(3).Src=     FOPXGET  20140128 UI14507D
    ErrCB.N(3).Func=    (004530) TableScanWithArcSubset
    ErrCB.N(4).Src=     FOPXGET  20140128 UI14507D
    ErrCB.N(4).Func=    (004211) SelectTableViaScan
    ErrCB.N(5).Src=     FOPXGET  20140128 UI14507D
    ErrCB.N(5).Func=    (001216) DXProcessTable
    ErrCB.N(6).Src=     FOPXGET  20140128 UI14507D
    ErrCB.N(6).Func=    (001630) DXProcessCycleCell
    ErrCB.N(7).Src=     FOPXMAIN 20140401 UI16544D
    ErrCB.N(7).Func=    (001102) DXDataExtract
    ErrCB.N(8).Src=     FOPXARSL 20140128 UI14507D
    ErrCB.N(8).Func=    (000631) DXArchiveSubset
    ErrCB.N(9).Src=     FOPUREST 20140401 UI16544D
    ErrCB.N(9).Func=    (003515) CreateSubset
    ErrCB.N(10).Src=     FOPUREST 20140401 UI16544D
    ErrCB.N(10).Func=    (001696) RestoreStatement
    ErrCB.N(11).Src=     FOPUMAIN 20140128 UI14507D
    ErrCB.N(11).Func=    (000797) FOPMMUTL_dynamn
    ErrCB.N(12).Src=     FOPMMAIN 20140224 UI15338D
    ErrCB.N(12).Func=    (000791) Main
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Optim/z users performing RESTORE.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The following problems are being addressed by this APAR:     *
  * o A System Error of:                                         *
  * IBM InfoSphere Optim System Error Structure - ErrCB          *
  * ErrCB.ID=      ZZZERRCBZZ                                    *
  * SysRel=        7.2.0                                         *
  * DB2Rel=        915(NFM)                                      *
  * ErrCB.Type=    Invalid Type                                  *
  * ErrCB.AuxInfo=                                               *
  * ErrCB.Code=    0                                             *
  * ErrCB.U.Buffer(Msg or SQLCA)=                                *
  * Number of Function Entries=  13                              *
  *   ErrCB.N(0).Src=     FOPXARSL 20131014 UK98459              *
  *   ErrCB.N(0).Func=    (001812) OpenCursor                    *
  *   ErrCB.N(1).Src=     FOPXARSL 20131014 UK98459              *
  *   ErrCB.N(1).Func=    (001544) GetSelectStrategy             *
  *   ErrCB.N(2).Src=     FOPXARSL 20131014 UK98459              *
  *   ErrCB.N(2).Func=    (000948) GetRowsFromArcFile            *
  *   ErrCB.N(3).Src=     FOPXGET  20131206 UI13315              *
  *   ErrCB.N(3).Func=    (004530) TableScanWithArcSubset        *
  *   ErrCB.N(4).Src=     FOPXGET  20131206 UI13315              *
  *   ErrCB.N(4).Func=    (004211) SelectTableViaScan            *
  *   ErrCB.N(5).Src=     FOPXGET  20131206 UI13315              *
  *   ErrCB.N(5).Func=    (001216) DXProcessTable                *
  *   ErrCB.N(6).Src=     FOPXGET  20131206 UI13315              *
  *   ErrCB.N(6).Func=    (001630) DXProcessCycleCell            *
  *   ErrCB.N(7).Src=     FOPXMAIN 20140328 UI16544              *
  *   ErrCB.N(7).Func=    (001102) DXDataExtract                 *
  *   ErrCB.N(8).Src=     FOPXARSL 20131014 UK98459              *
  *   ErrCB.N(8).Func=    (000631) DXArchiveSubset               *
  *   ErrCB.N(9).Src=     FOPUREST 20140328 UI16544              *
  *   ErrCB.N(9).Func=    (003515) CreateSubset                  *
  *   ErrCB.N(10).Src=     FOPUREST 20140328 UI16544             *
  *   ErrCB.N(10).Func=    (001696) RestoreStatement             *
  *   ErrCB.N(11).Src=     FOPUMAIN 20131114 UI12543             *
  *   ErrCB.N(11).Func=    (000797) FOPMMUTL_dynamn              *
  *   ErrCB.N(12).Src=     FOPMMAIN 20140220 UI15338             *
  *   ErrCB.N(12).Func=    (000791) Main                         *
  * may be reported during ARCHIVE RESTORE or EXTRACT INSERT     *
  * processing when processing files which contain tables        *
  * involved in relationships and no parent rows have been       *
  * archived for for some child tables.                          *
  * o The Optim Processing Report may not show all processed     *
  * tables or the row counts may be incorrect when the XF/AF     *
  * files contain empty tables.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the provided fix.                                      *
  ****************************************************************
  o Optim is not anticipating missing parent rows when following
  relationships from dependent tables during RESTORE or INSERT
  processing.
  o Optim is using flawed logic to report processed tables and row
  counts when processing ARCHIVE of EXTRACT files containing empty
  tables.
  

Problem conclusion

• Optim code will be changed to correct the processing of AF and
  XF containing empty tables.
  

Temporary fix

Comments

APAR Information

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

  PI17194

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

  UI17868

Modules/Macros

• FOPMDXTR FOPCFPMN FOPMDPRC FOPMTMDB
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• R710 PSY UI17868

     UP14/05/13 P F405 ½

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.