PH08202: CM BATCH OBJECT COMPARE ALTER INDEX NO REBUILD INDEX OR REORG GENERATED IN RUN JOB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A CM Batch or Object Compare job that generates an ALTER INDEX
  statement does not also generate the required REBUILD INDEX or
  REORG statement in the run job to make the ALTER effective.
  This APAR ensures that the appropriate statement is generated
  after the ALTER.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for z/OS  *
  *                 who add or alter partitions.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Alter on an index FREEPAGE or PCTFREE   *
  *                      values does not rebuild or reorg the    *
  *                      index.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using ALT, Compare, or Change Management to alter an index
  FREEPAGE or PCTFREE values, the execution of the 'run' job does
  not rebuild or reorg the index.
  

Problem conclusion

• Problem has been resolved.
  

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

•    ADB2CME
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI62635

     UP19/04/27 P F904

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.