A fix is available
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