PM52012: SUPPORT REORG_LIST_PROCESSING IN V10

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Support REORG_LIST_PROCESSING in V10
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/Os REORG utility users      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Introduction of a new zParm to control  *
  *                      the default behavior of REORG           *
  *                      TABLESPACE LIST partition processing.   *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available.         *
  ****************************************************************
  Currently by default behavior, REORG TABLESPACE LIST on a
  partitioned table space will result in a single REORG execution
  including all the adjacently specified partitions in the
  LISTDEF statement.
  
  For example:
  
  LISTDEF L INCLUDE TABLESPACE DBB.TSS PARTLEVEL 3
            INCLUDE TABLESPACE DBB.TSS PARTLEVEL 4
            INCLUDE TABLESPACE DBB.TSS PARTLEVEL 8
  REORG TABLESPACE LIST L
  
  The above will result in a single REORG execution reorganizing
  data partitions 3, 4 and 8 in the same utility operation, as if
  REORG TABLESPACE PART (3,4,8) is specified.
  
  While a new PARALLEL keyword is introduced via APAR PM25525 /
  PTF UK64588 to override this default behavior in a case by case
  basis, many users find this option limiting as they prefer the
  behavior of reorganizing LISTDEF partitions one at a time
  serially (e.g. due to DASD resource constraint) and they cannot
  modify a large number of utility jobs to specify the overriding
  PARALLEL keyword.
  
  As a result, this APAR introduces a new DB2 subsystem parameter
  ( zParm ) named REORG_LIST_PROCESSING.  This allows the user to
  specify the default setting of the PARALLEL option
  when deciding whether REORG would process the LISTDEF partitions
  in parallel or serially.
  

Problem conclusion

• Code has been modified to implement the aforementioned
  system zParm for REORG TABLESPACE LIST processing.
  

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:

  UK76650

Modules/Macros

• DSN@XAZP DSNDQWPZ DSNDSPRM DSNTIDXA DSNTIDXB
  DSNTIJUZ DSNTINST DSNTXAZP DSNUGDDM DSNWZIFA DSN6SPRM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK76650

     UP12/03/22 P F203

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.