PM37293: NEED ABILITY TO OVERRIDE REORG PARALLEL KEYWORD DEFAULT AT SYSTEM LEVEL.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • PM25525 introduced a new REORG keyword PARALLEL, to indicate
    how a 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.
    
    The default for this keyword is YES.  This maintains the
    behavior in effect after PK87762 has been applied, but changes
    the behavior prior to PK87762.  The customer needs the option to
    have the default behavior be as it was prior to PK87762.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS users of REORG TABLESPACE *
    *                 utility with LISTDEF.                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: Introduction of a new zParm to control  *
    *                      the default behavior of REORG           *
    *                      TABLESPACE LIST partition processing.   *
    ****************************************************************
    * RECOMMENDATION: Apply 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 partition 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 UK64590 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

Temporary fix

Comments

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

APAR Information

  • APAR number

    PM37293

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function

  • Submitted date

    2011-04-18

  • Closed date

    2011-07-06

  • Last modified date

    2012-02-20

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

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

    UK69494

Modules/Macros

  •    DSN@XAZP DSNDQWPZ DSNDSPRM DSNTIDXA DSNTIJUZ
    DSNTINST DSNTXAZH DSNTXAZP DSNUGDDM DSNWZIF9 DSN6SPRM
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK69494

       UP11/08/03 P F108

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:

910

Reference #:

PM37293

Modified date:

2012-02-20

Translate my page

Machine Translation

Content navigation