IBM Support

PH56415: REORG INCORRECTLY GENERATED FOR A PAGENUM RELATIVE TABLESPACE WHEN INCREASING TABLESPACE DSSIZE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Object Compare incorrectly generates a REORG for a PAGENUM
    RELATIVE tablespace when increasing the DSSIZE at the tablespace
     level. The alter is allowed to be done immediately without a
    REORG. Object Compare should not generate a REORG in this case.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    *                 and Db2 Object Comparison Tool for z/OS      *
    ****************************************************************
    * PROBLEM DESCRIPTION: Object Compare incorrectly generates a  *
    *                      REORG statement when increasing DSSIZE  *
    *                      at the tablespace level for PAGENUM     *
    *                      RELATIVE table spaces.                  *
    ****************************************************************
    Increasing the DSSIZE value for PAGENUM RELATIVE table spaces
    can be done immediately without a REORG operation. However,
    Object Compare generated an unnecessary REORG statement in this
    case. A REORG operation would still be needed if the new DSSIZE
    at the tablespace level is less than the value for any of the
    partitions.
    

Problem conclusion

  • The problem has been fixed. Object Compare will not generate a
    REORG statement when increasing DSSIZE for PAGENUM RELATIVE
    table spaces.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH56415

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    D10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-08-17

  • Closed date

    2023-11-22

  • Last modified date

    2023-12-02

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

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

    UI94594 UI94595

Modules/Macros

  • ADB2CME
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI94594

       UP23/11/28 P F311

  • RD10 PSY UI94595

       UP23/11/28 P F311

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.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 December 2023