PK87762: REORG ENHANCEMENT.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • Enhancement to the REORG utility in V9.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS users of REORG TABLESPACE *
    *                 and LISTDEF utility.                         *
    ****************************************************************
    * PROBLEM DESCRIPTION: New function for REORG TABLESPACE and   *
    *                      LISTDEF utility.                        *
    ****************************************************************
    * RECOMMENDATION: Apply PTF when available.                    *
    ****************************************************************
    New function for REORG TABLESPACE and LISTDEF utility.
    The Utility Guide and Reference is updated with the following:
    
    ________________________________________________________________
    
    The REORG TABLESPACE utility has extended syntax specification
    for the PART keyword:
    
    >-+--------------------------------------+---->
    |        +------------,------------+     |
    |        V                         |     |
    +-PART-(-+--+-integer-----------+--+-)---+
                +-integer1:integer2-+
    
    | The PART specification is extended to allow for multiple parts
    | or part ranges.  This applies to all SHRLEVEL of REORG
    | TABLESPACE.  REORG will eliminate duplicate and/or overlapping
    | partition range specifications.  Existing program logic will
    | issue MSGDSNU256I on invalid partition number specified and
    | terminate with return code 8.
    
    | Example:  REORG TABLESPACE PART (1, 3:5, 254:257)
    
    ________________________________________________________________
    
    The LISTDEF utility is changed so that it will invoke a single
    REORG TABLESPACE to process all the adjacently specified data
    partitions, instead of invoking a separate REORG on each
    specified partition.
    
    For example:  LISTDEF X INCLUDE TABLESPACE dbb.tss PARTLEVEL 3
                            INCLUDE TABLESPACE dbb.tss PARTLEVEL 5
                  REORG TABLESPACE LIST X
    
    Prior to PK87762, LISTDEF would invoke one REORG to process
    partition 3, follows serially by another REORG to process
    partition 5 in the above example.  After applying the PTF of
    PK87762, LISTDEF will invoke a single REORG to process partition
    3 and 5 in a single REORG job, as if REORG TABLESPACE PART(3,5)
    is specified.
    ________________________________________________________________
    

Problem conclusion

Temporary fix

Comments

  • Code has been modified to provide the aforementioned new utility
    function.
    ž**** PE10/09/16 FIX IN ERROR. SEE APAR PM22336  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PK87762

  • 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

    2009-06-02

  • Closed date

    2010-07-23

  • Last modified date

    2010-11-04

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

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

    UK59095

Modules/Macros

  •    DSNDUCA  DSNDUJB  DSNDURXA DSNDUSM  DSNDUSMM
    DSNDUSU  DSNDUTKN DSNUGDDM DSNUGDFL DSNUGPDS DSNUGPPM DSNUGPRT
    DSNUGPRV DSNUGRNG DSNUGUCA DSNUGULM DSNURBXA DSNURBXE DSNURFBR
    DSNURFIT DSNURPUI DSNURSCN
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK59095

       UP10/08/14 P F008

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

Document information


More support for:

DB2 for z/OS

Software version:

9.1

Reference #:

PK87762

Modified date:

2010-11-04

Translate my page

Machine Translation

Content navigation