PI99194: IMPLEMENT NEW EXCEPTIONS, INCLUDING DSNACCOX-LIKE EXCEPTION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This enhancement implements the following new features:
  1) Toggle display of the logical groups of Exception Conditions
  2) New DB2 DISPLAY status Exceptions ACHKP and PRO
  3) New Exception SYSINDEXES.COPY
  4) New DSNACCOX-like Exception Conditions
  5) New Exception REALTIME RUNSTATS.REORG_OR_LOAD and
  ICOPY.REBUILD
  6) New REALTIME Exceptions INSERTS, DELETES, and _PCTs,
  EMPTY_LEAF_PCT and Space Allocated to Space Used Ratio
  7) New Exception REALTIME REORG_TS.NO_REORG_LOAD
  8) New Exception REALTIME REORG_IX.NO_REORG_REBUILD
  9) New Exception SYSTABLES_PROFILES.PROF_UPDATED_RUNS2
  10) New Exception: OBJECT.CLONE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Automation Tool z/OS.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: This enhancement implements the         *
  *                      following new features:                 *
  *                      1. Toggle display of the logical        *
  *                       groups of Exception Conditions         *
  *                      2. New DB2 DISPLAY status Exceptions    *
  *                       ACHKP and PRO                          *
  *                      3. New Exception SYSINDEXES.COPY        *
  *                      4. New DSNACCOX-like Exception          *
  *                       Conditions                             *
  *                      5. New Exception REALTIME               *
  *                       RUNSTATS.REORG_OR_LOAD and             *
  *                       ICOPY.REBUILD                          *
  *                      6. New REALTIME Exceptions INSERTS,     *
  *                       DELETES, and _PCTs,                    *
  *                       EMPTY_LEAF_PCT and Space Allocated to  *
  *                       Space Used Ratio                       *
  *                      7. New Exception REALTIME               *
  *                       REORG_TS.NO_REORG_LOAD                 *
  *                      8. New Exception                        *
  *                       REALTIME REORG_IX.NO_REORG_REBUILD     *
  *                      9. New Exception                        *
  *                       SYSTABLES_PROFILES.PROF_UPDATED_RUNS2  *
  *                      10. New Exception: OBJECT.CLONE         *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UI57943

Modules/Macros

•    HAA$BUTL HAA$CALL HAA$DCVT HAA$EPRA HAA$EPRB
  HAA$EPRD HAA$EPRE HAA$EPRF HAA$EPRG HAA$EPRS HAA$EPRU HAA$EPRW
  HAA$EPRY HAA$ERRS HAA$ERSO HAA$ERST HAA$ESRB HAA$ESRC HAA$ESRG
  HAA$ESRI HAA$ESRL HAA$ESRM HAA$ESRO HAA$ESRT HAA$ESRX HAA$ESTC
  HAA$ESTM HAA$ETRG HAA$EXCP HAA$EXUX HAA$INEX HAA#BPRI HAA#ECDS
  HAA#ECIC HAA#EDSP HAA#EIDA HAA#EMIC HAA#EMID HAA#EOTR HAA#EPRI
  HAA#ERSH HAA#ERSI HAA#ERSU HAA#ERTI HAA#ESCP HAA#ETGI HAA#EXCS
  HAA#EXUX HAA#JPRI HAA#OBEX HAA#PRE  HAA#UTOB HAA@EMCS HAA@ETFU
  HAA@MVCR HAA@PEXC HAA@PRSS HAA@PTRG HAA@SDSC HAA@UREP HAABLNKT
  HAAHEPRA HAAHEPRB HAAHEPRF HAAHEPRG HAAHEPRS HAAHEPRU HAAHEPRV
  HAAHEPRY HAA61    HAA64    HAA645E  HAA647I  HAA651I  HAA652I
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R430 PSY UI57943

     UP18/08/23 P F808

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.