PK86685: UTIL PARTITION LEVEL RECOVER TABLESPACE DSNUM N TO USES REBUILD INDEX(<INDEX-NAME> PART N ) RATHER THAN INDEX(ALL)

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• The DB2 Administration Tool for z/OS panel ADB2US "Table Space
  Utilities" / UTIL command "Recover" options will now generate
  REBUILD INDEX syntax at the partition level as needed.
  For example:
     RECOVER TABLESPACE <dbname>.<tsname> DSNUM 4
       TORBA X'000000000000'
     REBUILD INDEX(<index-name>, <index-name2>, <index-name3>
     PART 4)
  rather then
     RECOVER TABLESPACE <dbname>.<tsname> DSNUM 4
    TORBA X'000000000000'
  REBUILD INDEX(ALL)
  

Local fix

• N/A New function
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who build jobs to RECOVER a             *
  *                 table space.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Indexes are unnecessarily rebuilt       *
  *                      during the recovery of table spaces.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Any recovery done at the partition level should not
  trigger a full rebuild of all of the indexes, they should
  only be rebuilt at the partition level.
  

Problem conclusion

Temporary fix

Comments

• Panel ADB2USV 'Specify Utility Options - RECOVER'  is
  modified to determine which indexes are associated with
  the table space.  The new EXEC ADBEUSV1 builds a table
  of indexes that are used later on in the file tailoring.
  ž**** PE11/02/10 PTF IN ERROR. SEE APAR PM32363  FOR DESCRIPTION
  ž**** PE11/04/14 PTF IN ERROR. SEE APAR PM26945  FOR DESCRIPTION
  

APAR Information

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

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

  UK64491 UK64492

Modules/Macros

•    ADBEUSV  ADB2US   ADB2USV  ADB2USV1 ADB21I
  ADB74
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK64491

     UP11/02/06 P F102

• R720 PSY UK64492

     UP11/02/06 P F102

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.