IBM Support

PH63752: OPTION 2 FROM UTILITY HISTORY PANEL ADB2Z2H DOES NOT DELETE THE ROWS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • User is on Db2 13 FL 504.
    User goes to the utility history panel, ADB2Z2H, using option Z
    and then 2H. User tries option 2 with Status = E and AGE >= 0
    days. it says it will delete all rows including the SYSOBJEVENTS
    entries...but when user hits enter....there is no message shown
    but no rows are being deleted. PROMPT SEL ON does not show any
    delete statement either.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    ****************************************************************
    * PROBLEM DESCRIPTION: Option 2 from utility history panel     *
    *                      ADB2Z2H does not delete the rows in the *
    *                      utility history table.                  *
    ****************************************************************
    A user navigates to utility history panel ADB2Z2H and selects
    option 2 with Status = E and AGE >= 0 days. The panel reports
    that it will delete all rows, including the SYSOBJEVENTS
    entries. However, when the user presses Enter, no message is
    displayed, and no rows are deleted.
    

Problem conclusion

  • The problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH63752

  • 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

    2024-10-16

  • Closed date

    2025-01-27

  • Last modified date

    2025-02-03

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

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

    UI99751

Modules/Macros

  • ADB2Z2H
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RD10 PSY UI99751

       UP25/01/30 P F501

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:
03 February 2025