PH45361: Panel HAA$UMOD: Adding field "Process Define No Objects" for MODIFY STATISTICS utility - for both TS and IX objects

APAR status

• Closed as program error.

Error description

• A new field (Process Define No Objects) is being added to the
  Modify Options Panel (HAA$UMOD) for the MODIFY STATISTICS
  utility.  When specifying LISTDEFS, this new field will allow
  the keyword "DEFINED ALL" keyword to be added to the LISTDEF
  control cards - which will include objects created with either
  DEFINE YES or DEFINE NO.  Acceptable values for this new field
  will be Y or N - with the default being "N".
  Without LISTDEFS, this new field will include objects created
  with either DEFINE YES or DEFINE NO. Acceptable values for this
  new field will be Y or N - with the default being "N".
  A value of "Y" will allow the MODIFY STATISTICS utility to
  delete unwanted statistics history records from the
  corresponding catalog tables for tablespaces and indexes defined
  with either DEFINE YES or DEFINE NO.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: A new field (Include Define No Objects) *
  *                      is being added to the Modify Options    *
  *                      Panel (HAA$UMOD) for the MODIFY         *
  *                      STATISTICS utility. When specifying     *
  *                      LISTDEFS, this new field will allow the *
  *                      keyword "DEFINED ALL" keyword to be     *
  *                      added to the LISTDEF control cards -    *
  *                      which will include objects created with *
  *                      either DEFINE YES or DEFINE NO.         *
  *                      Acceptable values for this new field    *
  *                      will be Y or N - with the default being *
  *                      N.                                      *
  *                                                              *
  *                      Without LISTDEFS, this new field will   *
  *                      include objects created with either     *
  *                      DEFINE YES or DEFINE NO. Acceptable     *
  *                      values for this new field will be "Y"   *
  *                      or "N" - with the default being "N".    *
  *                                                              *
  *                      A value of "Y" will allow the MODIFY    *
  *                      STATISTICS utility to delete unwanted   *
  *                      statistics history records from the     *
  *                      corresponding catalog tables for        *
  *                      tablespaces and indexes defined with    *
  *                      either DEFINE YES or DEFINE NO.         *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF                                *
  ****************************************************************
  .
  

Problem conclusion

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

• HAA#BND  HAA#BPRI HAA#OBEX HAA#PEND HAA#UPRI HAA#UTED HAA#UTOB
  HAA$BMSG HAA$BUTM HAA$DS2  HAA$DSD  HAA$SV26 HAA$UMOD HAA$UREO
  HAA68    HAA684E  HAAHDS2  HAAHDSD  HAAHUMOD HAAHUREO HAAHVMOD
  HAAHVREO HAALISTC
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels