PH28092: REORG PI PARALLEL BUILD IMPROVEMENT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• REORG PI parallel BUILD improvement for partitioning indexes
  when running on a table space with a single PI
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of REORG                           *
  * TABLESPACE SHRLEVEL REFERENCE or CHANGE                      *
  * utility                                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Enable REORG TABLESPACE SHRLEVEL                             *
  * REFERENCE or CHANGE to build the                             *
  * partitions of the clustering                                 *
  * partitioned index in parallel                                *
  * during the RELOAD phase                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR enables REORG TABLESPACE running with SHRLEVEL
  REFERENCE or CHANGE with data unload/reload partition
  parallelism to skip the sorting of the clustering partitioned
  index (PI) and to build the PI partitions in parallel during
  the RELOAD phase.
  The enhancement takes place when all of the following
  criteria are met:
  - REORG TABLESPACE SHRLEVEL REFERENCE or CHANGE is run on a
    multi-part range partitioned table space with only one
    clustering partitioned index defined on the table involved,
    with no other indexes defined
  - REORG is sorting the data records into clustering order
    with the default or specified SORTDATA YES option
  - Data unload/reload partition is used on the REORG with
    message DSNU1160I issued
  - REBALANCE is not specified
  When the above scenario is in effect, REORG will spawn off
  additional build tasks to perform the parallel PI build during
  the RELOAD phase, with potentially some index sort tasks
  attached but sorting zero records.
  

Problem conclusion

Temporary fix

Comments

• Code has been modified to implement the aforementioned new
  function for REORG to build PI partitions in parallel.
  ×**** PE20/10/27 FIX IN ERROR. SEE APAR PH30979  FOR DESCRIPTION
  ×**** PE21/02/08 FIX IN ERROR. SEE APAR PH34284  FOR DESCRIPTION
  ×**** PE21/07/05 FIX IN ERROR. SEE APAR PH36695  FOR DESCRIPTION
  ×**** PE21/07/07 FIX IN ERROR. SEE APAR PH38725  FOR DESCRIPTION
  

APAR Information

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

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

  UI71385

Modules/Macros

• DSNURBXE DSNURBXD DSNURPTB DSNURKAC DSNURPRD DSNURFIT DSNURPCT
  DSNURPUI DSNURBXA DSNUGUTC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI71385

     UP20/09/10 P F009

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.