IBM Support

PH30078: UNNECESSARY OBJECTS ARE PROCESSED DURING THE REDIRECTED RECOVERY

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Additional objects may be implicitly included in the recovery
    scope as indirect dependencies of objects explicitly selected
    for recovery (e.g. recovered view based on several tables).
    If such additional objects do not exist during the recovery,
    they need to be created to avoid SQL errors during the DDL
    execution. But no other actions need to be performed for such
    objects.
    During the redirected recovery, unnecessary JCL steps (including
    STOP and START) were generated for such implicitly selected
    objects. If no translation masks were specified that may be
    applied to such objects, source object names were used in the
    JCL steps. Incorrect REDIRECTED_RECOVERY steps with empty GROUP
    statement may be also generated for such scenarios.
    

Local fix

  • Any related objects that should not be recovered, may
    be explicitly added to application profiles as "excluded".
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Recovery Expert for z/OS.       *
    ****************************************************************
    * PROBLEM DESCRIPTION: Additional objects may be implicitly    *
    *                      included in the recovery scope as       *
    *                      indirect dependencies of objects        *
    *                      explicitly selected for recovery        *
    *                      (e.g. recovered view based on several   *
    *                      tables). If such additional objects do  *
    *                      not exist during the recovery, they     *
    *                      need to be created to avoid SQL errors  *
    *                      during the DDL execution. But no other  *
    *                      actions need to be performed for such   *
    *                      objects.                                *
    *                                                              *
    *                      During the redirected recovery,         *
    *                      unnecessary JCL steps (including STOP   *
    *                      and START) were generated for such      *
    *                      implicitly selected objects. If no      *
    *                      translation masks were specified that   *
    *                      may be applied to such objects, source  *
    *                      object names were used in the JCL       *
    *                      steps. Incorrect REDIRECTED_RECOVERY    *
    *                      steps with empty GROUP statement may be *
    *                      also generated for such scenarios.      *
    *                                                              *
    *                      As a workaround, any related objects    *
    *                      that should not be recovered, may be    *
    *                      explicitly added to application         *
    *                      profiles as "excluded".                 *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    .
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH30078

  • Reported component name

    DB2 REC EXPERT

  • Reported component ID

    5697H7400

  • Reported release

    320

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-09-30

  • Closed date

    2020-10-28

  • Last modified date

    2020-11-02

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

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

Modules/Macros

  • ARY#A001 ARY#ACIR ARY#ACIW ARY#ACON ARY#ACRD ARY#ACUP ARY#ADIS
    ARY#ADSC ARY#AEXT ARY#AFMT ARY#AFRR ARY#ALLO ARY#AMIN ARY#ASYS
    ARY#AUMX ARY#CARD ARY#CHKR ARY#CLLS ARY#CMTS ARY#CNTL ARY#CPNT
    ARY#CPOL ARY#DSAF ARY#DSPL ARY#DYNL ARY#ENCR ARY#ENQS ARY#ENVF
    ARY#FCPY ARY#ICAI ARY#ICAL ARY#ICCC ARY#ICCI ARY#IDCF ARY#IDSA
    ARY#IERR ARY#IHSA ARY#IKPL ARY#IKPN ARY#ILGP ARY#ILRA ARY#ILRS
    ARY#ILSA ARY#INIT ARY#IPIE ARY#IPPB ARY#IPPC ARY#IPPD ARY#IPPH
    ARY#IPPL ARY#IPPN ARY#IPPS ARY#IRPL ARY#ISNA ARY#LGAA ARY#LGAC
    ARY#LGAF ARY#LGAI ARY#LGAP ARY#LOGR ARY#LRD6 ARY#MAIN ARY#MDRV
    ARY#MLOG ARY#MMGR ARY#MREP ARY#MTIO ARY#OBRP ARY#OS   ARY#PRNG
    ARY#QSAM ARY#RANG ARY#RESM ARY#RPRP ARY#RUNT ARY#STAT ARY#SUBD
    ARY#SUBX ARY#SYSC ARY#TUTL ARY#UTLS ARY#VERS ARY#VSM  ARY#WRIT
    ARY#XMLD ARY#XMLI ARY#XMLJ ARY#XMLS ARY#XMLU ARY$ACCS ARY$ZPAR
    ARY3MEPI ARY3MEPL ARYALL99 ARYAPOST ARYBBCFO ARYBBCK  ARYBBGOC
    ARYBDT@  ARYCAPST ARYCUTL  ARYDB2CN ARYDB2PR ARYDB2SQ ARYDECIM
    ARYDLL   ARYDTST  ARYEQUAL ARYFTRT  ARYGMAIN ARYGPLNL ARYICAPS
    ARYIDTPS ARYIENQS ARYJRDT@ ARYJRGEN ARYJRGJU ARYJRXLN ARYLGAPS
    ARYLGPR  ARYLGRD  ARYLJGCR ARYLJGPL ARYLJGPX ARYLJXAO ARYMMGR
    ARYMSGPC ARYOBJST ARYPARET ARYPGPR  ARYPRSR  ARYS1ICA ARYS2IDT
    ARYS3LGA ARYS4XSI ARYS5XDI ARYS6XDU ARYS99   ARYSA001 ARYSACIR
    ARYSACIW ARYSACON ARYSACRD ARYSACUP ARYSADIS ARYSADSC ARYSAEXT
    ARYSAFMT ARYSAFRR ARYSALLO ARYSAUMX ARYSCLLS ARYSDYNL ARYSMDRV
    ARYSMNIN ARYSMTIO ARYSOS   ARYSQSAM ARYSTUTL ARYSUTLS ARYSVSAM
    ARYXAS31 ARYXAS64 ARYXASMS ARYXASPR ARYXDDM  ARYXDIPS ARYXDUPS
    ARYXEXPM ARYXMLST ARYXPDS  ARYXSIPS ARYXUTLS
    

Fix information

  • Fixed component name

    DB2 REC EXPERT

  • Fixed component ID

    5697H7400

Applicable component levels

  • R320 PSY UI72300

       UP20/10/30 P F010

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0"}]

Document Information

Modified date:
12 February 2021