PK95732: CM WSL CONTAINS INDIVIDUAL REBUILD INDEX STATEMENTS INSTEAD OF REBUILD INDEX(INDEX1, INDEX2, INDEXNN )

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS Change Management feature
  built a WSL with individual REBUILD INDEX statements rather than
  REBUILD INDEX(index1, index2, indexnn ) which would have allowed
  the DB2 REBUILD INDEX utility to process the indices in parallel
  wherein the utility would have issued the message:
  DSNU395I DSNUCRIB - INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF
  TASK N
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration and              *
  *                 DB2 Object Comparison Tool for               *
  *                 z/OS who use Change                          *
  *                 Management.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Multiple REBUILD index                  *
  *                      statements are generated, even          *
  *                      if indexes belong to the same           *
  *                      table space, resulting in poor          *
  *                      performance.                            *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  One rebuild statement will be generated to rebuild
  multiple indexes of the same table space. This will
  allow the indexes of the same table space to be
  built in parallel.
  

Problem conclusion

• The 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:

  UK56303

Modules/Macros

•    GOCGAJOB
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK56303

     UP10/04/28 P F004

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.