IBM Support

PH50947: DB2 ADMIN TOOL INTERFACE TO SQLPA

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Db2 Admin Tool Interface to SQLPA
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR provides an interface in Db2  *
    *                      Admin Tool to Db2 SQL Performance       *
    *                      Analyzer (SQL PA).                      *
    ****************************************************************
    This APAR integrates Db2 Admin Tool and Db2 SQL PA
    to seamlessly explain a statement during administrative
    operations, so that the user does not need to switch between
    tools.
    A new installation-dependent line command, PA (Explain with Db2
    SQL PA), was added on panel ADB21K (Packages) to launch
    Db2 SQL PA.
    To enable this command, the following new options have been
    added to the IBM Tools Customizer for z/OS (TCz) setup process
    for Db2 Administration Tool on panel CCQPPRD 'Product
    Parameters' and panel CCQPDB2 'DB2 Parameters':
      - Enable Db2 SQL PA (Yes/No)
      - SQL PA CLIST lib
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH50947

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    D10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2022-11-16

  • Closed date

    2023-01-31

  • Last modified date

    2023-03-01

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

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

    UI90350

Modules/Macros

  • ADB$$PRM ADB21K   ADB2CUST ADBC32   ADBCUST  ADBESQPA ADBR
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RD10 PSY UI90350

       UP23/02/03 P F302  

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 March 2023