PM52012: SUPPORT REORG_LIST_PROCESSING IN V10

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM52012

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / CST

  • Submitted date

    2011-11-11

  • Closed date

    2012-03-06

  • Last modified date

    2012-04-09

  • 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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM52012

Modified date:

2012-04-09

Translate my page

Machine Translation

Content navigation