IBM Support

PI44797: DET/PACKAGE DETAILS COMMAND MISSING DETAILS ON PANEL ADBPD 'DETAILS FOR OBJECT(S)' AFTER APAR PI26570

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The DB2 Administration Tool for z/OS' DET 'Package details'
    line command output shown on panel ADBPD 'Details for object(s)'
    does not show the details for packages bound on DB2 R710 and
    earlier after APAR PI26570's PTF is applied.
    

Local fix

  • Rebind the packages on a DB2 R810 or higher subsystem.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool for     *
    *                 z/OS who issue the 'DET - Package details'   *
    *                 line command to display a detailed report    *
    *                 on packages.                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: When issuing the 'DET - Package         *
    *                      details' command against packages on    *
    *                      panel ADB21K 'Packages' that were       *
    *                      bound prior to DB2 R810, SQL            *
    *                      statements of the packages are not      *
    *                      displayed in the report.                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When issuing the 'DET - Package details' command against a
    package on panel ADB21K 'Packages' that were bound prior to
    DB2 R810, SQL statements of the packages are not displayed
    in the report.
    

Problem conclusion

  • The problem has been resolved. The user should be able to see
    the SQL statements of the packages bound prior to DB2 R810 as
    well.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI44797

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-07-10

  • Closed date

    2015-10-02

  • Last modified date

    2015-11-03

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

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

Modules/Macros

  • ADBDK    ADB0     ADB2FMT
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RB10 PSY UI31746

       UP15/10/06 P F510

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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 November 2015