PH48016: SUPPORT FOR COMPARE SMART REORG GENERATION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Compare Smart REORG Generation
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who compare tables in PBR table spaces with  *
  *                 a different number of partitions             *
  ****************************************************************
  * PROBLEM DESCRIPTION: When comparing PBR table spaces and     *
  *                      the source has more partitions than     *
  *                      target, the resulting work statement    *
  *                      list (WSL) has too many REORG           *
  *                      operations.                             *
  ****************************************************************
  The user is comparing tables in PBR table spaces and the source
  has more partitions than the target. Instead of adding
  partitions with an ADD PARTITION clause at the appropriate
  partition position, Db2 Admin Tool alters the last partition by
  using an ALTER statement with an ADD PARTITION (MAXVALUE)
  clause followed by an ALTER statement with an ALTER PARTITION
  clause. This ALTER process results in too many REORG operations.
  

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:

  UI82192 UI82194

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI82192

     UP22/10/03 P F209

• RD10 PSY UI82194

     UP22/10/03 P F209

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.