PK30087: REBUILD INDEX OF AN NPI WITH ZIIP EXPERIENCES 10% ELAPSED TIME DEGRADATION IN THE BUILD PHASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• REBUILD INDEX of a single NPI over a partitioned table space
  may experience up to 10% elapsed time degradation in the BUILD
  phase with zIIP.
  KEYWORD: ZIIP/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS utility users.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: REBUILD INDEX of a single               *
  *                      non-partitioning index (NPI) might      *
  *                      experience up to a 10% elapsed time     *
  *                      degradation in the BUILD phase.         *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available.         *
  ****************************************************************
  REBUILD INDEX of an entire NPI (not just a logical part) with
  zIIP support installed might experience up to a 10% elapsed time
  degradation in the BUILD phase.  The elapsed time increase is
  dependent on the lengths of the index keys.  Indexes with
  smaller key lengths would see larger degradations than those
  with larger key lengths.
  

Problem conclusion

• REBUILD INDEX has been modified to correct the degradation.
  

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:

  UK18276

Modules/Macros

• DSNUCRIB
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK18276

     UP06/10/10 P F610

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.