PK19285: DB2 OBJECT COMPARISON TOOL DOES NOT GENERATE RUNSTATS FOR ALL INDEXES (ALSO, REFERENCE PK14499)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• .*
  DB2 OBJECT COMPARISON TOOL DOES NOT GENERATE RUNSTATS
  FOR ALL INDEXES (ALSO, REFERENCE PK14499)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool, who     *
  *                 request  RUNSTATS  Utility option A or B     *
  *                 for  the  APPLY  processing and creating     *
  *                 multiple  new  indexes  against the same     *
  *                 table, are affected.                         *
  *                 .* Note: Also, see PK14998.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2  Object  Comparison  Tool does not  *
  *                      generate RUNSTATS for all indexes.      *
  *                      .*                                      *
  *                      When requesting RUNSTATS Utility option *
  *                      A  or  B  for the  apply processing and *
  *                      creating  multiple  new indexes against *
  *                      the  same  table,  the   generation  of *
  *                      RUNSTATS Utilities  for  all  the newly *
  *                      created   indexes   was  not  correctly *
  *                      supported.                              *
  *                      .*                                      *
  *                      Note:  Per  PK05668  and  PK14499,  "No *
  *                      RUNSTAT  utility  is  created for newly *
  *                      created indexes  when the table is also *
  *                      new."                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Now,  exec  GOCGAJOB has been modified to correctly support
  the  generation  of  RUNSTATS  Utilities  for all the newly
  created  indexes  for  the  situation  where  users request
  RUNSTATS Utility option A or B for the APPLY processing and
  creating multiple new indexes against the same table.
  (However, when the table is also new, No RUNSTATS Utility
  is generated. See PK05668 and PK14499)
  

Problem conclusion

• Apply the fix.
  

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

•    GOCGAJOB
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R310 PSY UK12028

     UP06/03/01 P F602

• R710 PSY UK12029

     UP06/03/01 P F602

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.