PM41874: ADD OPTION TO CREATE INDEX RUNSTATS AT THE PARTITION LEVEL AS PART OF TABLESPACE RUNSTATS.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Add on option on the Runstats Utility Panel to indicate that
  Runstats are to be generated at the partition level for indexes.
  Currently, the only option for generating Runstats for indexes
  while generating Runstats for tablespaces is to use INDEX(ALL).
  This new option will allow partition level index Runstats as
  part of the Tablespace Runstats.  For example:
  RUNSTATS TABLESPACE DBNAME.TSNAME
  PART 3
  INDEX(DBNAME.IDXNAME PART 3)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Add on option on the Runstats Utility   *
  *                      Panel to indicate that Runstats are to  *
  *                      be generated at the partition level     *
  *                      for indexes. Currently, the only        *
  *                      option for generating Runstats for      *
  *                      indexes while generating Runstats for   *
  *                      tablespaces is to use INDEX(ALL).       *
  *                      This new option will allow partition    *
  *                      level index Runstats as part of the     *
  *                      Tablespace Runstats.  For example:      *
  *                      RUNSTATS TABLESPACE DBNAME.TSNAME       *
  *                      PART 3                                  *
  *                      INDEX(DBNAME.IDXNAME PART 3)            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

• Apply the PTF.
  

APAR Information

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

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

  UK74526

Modules/Macros

• HAA$BMSG HAA$BUTT HAA$URST HAA$VRST HAA#OBEX
  HAA#UPRI HAA#UTED HAA#UTOB HAABTMP  HAAHURST HAAHVRST HAARUNSC
  HAA37    HAA375E  HAA56    HAA569E  HAA58    HAA585E
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R310 PSY UK74526

     UP11/12/17 P F112

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.