PH25223: ENHANCEMENTS TO THE EXTRACT/ARCHIVE PROCESSING REPORTS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR introduces enhancements to the processing Optim
  reports generated during the execution of the following
  functions:
  o ARCHIVE
  o EXTRACT
  o SUBSET
  o Selective RESTORE.
  
  New report sections will be added to document the Optim
  relationship processing steps as well as index analysis for
  the used relationships.
  These reports may provide customers with better understanding
  and documentation of how Optim determined the table processing
  order and the relationships being followed and how they
  contributed to the row count.
  The relationship and index analysis section may help in creation
  of additional indexes which may improve processing performance.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Optim users performing EXTRACT, ARCHIVE,     *
  *                  Selective RESTORE and SUBSET processing.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR introduces enhancements to    *
  *                      the processing Optim reports generated  *
  *                      during the execution of the following   *
  *                      functions:                              *
  *                      o ARCHIVE                               *
  *                      o EXTRACT                               *
  *                      o SUBSET                                *
  *                      o Selective RESTORE.                    *
  *                                                              *
  *                      New report sections will be added to    *
  *                      document the Optim relationship         *
  *                      processing steps as well as index       *
  *                      analysis for the used relationships.    *
  *                      These reports may provide customers     *
  *                      with better understanding and           *
  *                      documentation of how Optim determined   *
  *                      the table processing order and the      *
  *                      relationships being                     *
  *                      followed and how they contributed to    *
  *                      the row count.                          *
  *                      The relationship and index analysis     *
  *                      section may help in creation of         *
  *                      additional indexes which may improve    *
  *                      processing performance.                 *
  ****************************************************************
  * RECOMMENDATION: Apply the fix provided.                      *
  ****************************************************************
  This is useability and functionality enhancement.
  

Problem conclusion

• Optim processing will be enhanced as follows:
  New report sections will be added to document the Optim
  relationship processing steps as well as index analysis for the
  used relationships.
  These reports may provide customers with better understanding
  and documentation of how Optim determined the table processing
  order and the relationships being
  followed and how they contributed to the row count.
  The relationship and index analysis section may help in creation
   of additional indexes which may improve processing performance.
  

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

• FOP00B   FOP01B   FOP05B   FOP1ODRV FOP1OSFN FOP4PEMN FOP4PMMN
  FOP4SVC  FOP4TRCE FOP4XCCN FOP4XEML FOP4XSSN FOP9APIM FOPCFPMN
  FOPCXLIB FOPD2VNN FOPDC002 FOPDC003 FOPHSTM  FOPJCLUT FOPMADDE
  FOPMAIN  FOPMAMAI FOPMARCN FOPMCBMN FOPMCENU FOPMCMAI FOPMCMMN
  FOPMCOFN FOPMCOLA FOPMCOLP FOPMDBMN FOPMDDDL FOPMDPRC FOPMDXTR
  FOPMECMN FOPMIXMM FOPMMCMR FOPMMJBS FOPMMUNU FOPMMUTL FOPMSELM
  FOPMUXIM FOPODPP  FOPOMN   FOPRS10  FOPRS3   FOPRS4   FOPRS7
  FOPRS8   FOPT0P10 FOPTCM02 FOPTDM01 FOPTDMAP FOPTPCVE FOPTUO48
  FOPTUO49 FOPUMCBT FOPZFBMN FOPZFMMN FOPZMAIN
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI69897

     UP20/06/06 P F006  

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.