IBM Support

PH48508: ELIMINATE ADMIN DROP CREATE IN ALT TABLESPACE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as unreproducible in next release.

Error description

  • Eliminate ADMIN DROP CREATE in ALT Tablespace
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    *                 and Db2 Object Comparison Tool for z/OS      *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1. Db2 Administration Tool uses ADMIN   *
    *                      DROP followed by a pseudo CREATE during *
    *                      the ALT TABLESPACE process to apply     *
    *                      changes.                                *
    *                      2. Inflight values are not saved during *
    *                      the ALT TABLESPACE process on the       *
    *                      'Redefine Table Space' panel            *
    *                      (ADB21SAR).                             *
    ****************************************************************
    This APAR provides the following enhancements:
    
    1. The ALT TABLESPACE process is changed to generate ALTER
    and ADMIN ALTER statements instead of ADMIN DROP and CREATE
    TABLESPACE statements.
    2. Values that were set on the 'Redefine Table Space' panel
    (ADB21SAR) are saved during the ALT TABLESPACE process and
    are displayed correctly after applying line command 'A' (Alter
    object) on the 'Alter Objects' panel (ADB27CA).
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH48508

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    D10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-08-08

  • Closed date

    2022-08-15

  • Last modified date

    2022-09-01

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

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

    UI81942

Modules/Macros

  • ADB21SA  ADB21SAR ADB21TAV ADB2CME
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RD10 PSY UI81942

       UP22/08/17 P F208

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:
01 September 2022