IBM Support

PH63355: THE ABSENCE OF STORED PROCEDURE ADBGDDL CAUSES DROPS OF OTHER OBJECTS AND THE FREEING OF PACKAGES AND PLAN.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When a users tries to update a subsystem, if the stored
    procedure ADBGDDL does not exist, all of the other Db2 Admin
    related objects created during subsystem registration are
    dropped and recreated. This APAR will update logic not to drop
    those other objects in the use case where the stored procedure
    is missing.Release:  UMS 1.2 base and its all maintenance
    releases.
    
    Users affected: Users of the Db2 DevOps Experience for z/OS
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the IBM Unified Management Server   *
    *                 for z/OS and the following experiences:      *
    *                 - Db2 DevOps Experience for z/OS             *
    *                 - Db2 Administration Foundation for z/OS     *
    ****************************************************************
    * PROBLEM DESCRIPTION: The absence of stored procedure ADBGDDL *
    *                      causes drops of other objects and the   *
    *                      freeing of packages and plan.           *
    ****************************************************************
    When a users tries to update a subsystem, if the stored
    procedure ADBGDDL does not exist, all of the other Db2 Admin
    related objects created during subsystem registration are
    dropped and recreated. This APAR will update logic not to drop
    those other objects in the use case where the stored procedure
    is missing.
    

Problem conclusion

  • Apply the PTF provided by this APAR
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH63355

  • Reported component name

    UNIFIED MGMT SV

  • Reported component ID

    5698UM100

  • Reported release

    120

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2024-09-23

  • Closed date

    2024-11-12

  • Last modified date

    2024-12-03

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

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

Modules/Macros

  • IZP2IFIP IZPD2A   IZPD2R   IZPD2T   IZPD2VA  IZPD2VR  IZPD2VT
    IZPD3T   IZPD3VT  IZPDAJP  IZPDATPP IZPDISCP IZPHLVP  IZPJOBSP
    IZPMNFST IZPSERVE IZPUI    IZPUSCP
    

Fix information

  • Fixed component name

    UNIFIED MGMT SV

  • Fixed component ID

    5698UM100

Applicable component levels

  • R120 PSY UI99021

       UP24/11/20 P F411

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":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"120"}]

Document Information

Modified date:
03 December 2024