IBM Support

PH41451: DB2 ADMIN TOOL PANEL ADB21F COMMAND DPK DOESN'T WORK IF SPECIFIC NAME DIFFERENT THAN FUNCTION NAME.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The SQL used for line command DPK against a Function does not
    return the correct result.
    The reason for this is that the query used references the
    Function Name and not the Function Specific Name. It is ok if
    the Function Name is the same as the Function Specific Name.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    ****************************************************************
    * PROBLEM DESCRIPTION: On panel ADB21F, line command DPK does  *
    *                      not work if the specific name is        *
    *                      different than the function name.       *
    ****************************************************************
    The user issues line command DPK on the function panel (ADB21F)
    and receives error "No Rows Returned".  This behavior is wrong,
    as the user knows that the function has package dependencies.
    This problem occurs only on functions that have an explicit name
    that is different than the function name.
    

Problem conclusion

  • The problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH41451

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-10-20

  • Closed date

    2022-01-21

  • Last modified date

    2022-02-01

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

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

    UI79012

Modules/Macros

  • ADB21F
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI79012

       UP22/01/25 P F201

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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":"12.1.0"}]

Document Information

Modified date:
02 February 2022