PM25525: REORG OF MULTIPLE PARTITIONS USING THE NEW SYNTAX PROVIDED BY PK87762 AND PM13259 CAUSES MORE DEMAND OF SORT WORK SPACE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • After the Reorg enhancements provided by PK87762 and
    PM13259, the LISTDEF utility is changed so that it will invoke
    a singleREORG TABLESPACE to process all the *adjacently*
    specified data partitions, instead of invoking a separate
    REORG on each specified partition.
    Prior to PK87762, LISTDEF would invoke one REORG to process
    a partition , followed serially by another REORG to process
    another partition, and so on...
    After applying the PTF of PK87762, LISTDEF will invoke a
    REORG to process all the specified partitions in parallel and
    this new behavior is causing customer severe problems with
    sort space (i..e like abend04e rc00E40005, msgice046A, etc..),
    as obviously the sort space required is higher.
    What would be needed by customer is the choice to have an option
    on LISTDEF that would force the utility to process one or more
    partitions serially to have a lower demand of sort work space.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS or DB2 10 for z/OS users  *
    *                 of the REORG TABLESPACE utility with the     *
    *                 LIST keyword.                                *
    ****************************************************************
    * PROBLEM DESCRIPTION: With the REORG TABLESPACE enhancement   *
    *                      PTF for APAR PK87762 the REORG          *
    *                      TABLESPACE utility uses an increased    *
    *                      amount of sort work space to process    *
    *                      partitions in parallel.  This amount    *
    *                      of sort work space may not be           *
    *                      available to process a large number of  *
    *                      partitions.                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    A mechanism is needed to bypass parallel processing of
    partitions.
    

Problem conclusion

  • A new keyword has been added to the REORG TABLESPACE LIST
    utility control statement by this APAR/PTF.  The following
    option description is added to the REORG TABLESPACE chapter
    of the Utility Guide and Reference:
    
      PARALLEL
    
        The PARALLEL keyword indicates how the specified LIST is
        to be processed.  It applies to the partitions of an
        individual table space which are specified on the LISTDEF
        control statement with the PARTLEVEL keyword.
    
        YES
           If multiple partitions for an individual table space
           exist in the LISTDEF list, they will be processed
           in parallel on a single invocation of the REORG utility.
           YES is the default.
    
        NO
           If multiple partitions for an individual table space
           exist in the LISTDEF list, they will be processed
           serially, one at a time on individual invocations of the
           REORG utility.
    
           Specify PARALLEL NO when insufficient system resources
           are available to process a large number of partitions
           in parallel.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM25525

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-10-29

  • Closed date

    2011-02-04

  • Last modified date

    2011-03-02

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

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

    UK64588 UK64590

Modules/Macros

  •    DSNDUSMM DSNUGDDM DSNUGPRT DSNUGTTM DSNUGULM
    

Publications Referenced
SC19298400 SC18985500      

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK64588

       UP11/02/22 P F102

  • R910 PSY UK64590

       UP11/02/22 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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

9.1

Reference #:

PM25525

Modified date:

2011-03-02

Translate my page

Machine Translation

Content navigation