A fix is available
APAR status
Closed as new function.
Error description
Enhance EXPLAIN table maintenance.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Db2 Administration Tool for z/OS 13.1 users * * who use the EXPLAIN tables * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides enhancements to the * * EXPLAIN table maintenance. * **************************************************************** Db2 for z/OS updated the format of the Db2 EXPLAIN tables to support IBM Db2 AI for z/OS. Db2 APAR PH44421 added new EXPLAIN table columns, and Db2 APAR PH48053 provided support for converting EXPLAIN tables to the new format. Db2 Admin Tool provides support for these changes. You can use the panel interface to upgrade your EXPLAIN tables to the current format. Db2 Admin Tool performs this upgrade by calling the new Db2 stored procedure ADMIN_EXPLAIN_MAINT. This APAR provides the following enhancements to the EXPLAIN table maintenance: - Replaces the following options on panel ADB2E (Main menu->E) with the new MNT option that supports the CREATE, UPGRADE and DROPALL actions for the EXPLAIN tables: CT - Create a table used by EXPLAIN CX - Create an index for the table UT - Upgrade a table to current DB2 version CA - Create an alias for the table - Uses the Db2-provided stored procedure ADMIN_EXPLAIN_MAINT to upgrade the EXPLAIN tables to the format for the current Db2 version. - Expands the supported EXPLAIN tables from the previously supported 8 tables to 23 tables. Previously the following 8 EXPLAIN tables are supported: PLAN_TABLE DSN_STATEMNT_TABLE DSN_FUNCTION_TABLE DSN_STATEMENT_CACHE_TABLE DSN_QUERYINFO_TABLE DSN_PREDICAT_TABLE DSN_USERQUERY_TABLE DSN_PREDICATE_SELECTIVITY This enhancement supports the following additional EXPLAIN tables: DSN_FILTER_TABLE DSN_DETCOST_TABLE DSN_COLDIST_TABLE DSN_KEYTGTDIST_TABLE DSN_VIRTUAL_INDEXES DSN_VIRTUAL_KEYTARGETS DSN_PGRANGE_TABLE DSN_PGROUP_TABLE DSN_PTASK_TABLE DSN_QUERY_TABLE DSN_SORTKEY_TABLE DSN_SORT_TABLE DSN_STAT_FEEDBACK DSN_STRUCT_TABLE DSN_VIEWREF_TABLE - Migrates the 'CX - Create an index for the table' functionality to the Db2-provided stored procedure ADMIN_EXPLAIN_MAINT. Keywords: EXPLAIN ADMIN_EXPLAIN_MAINT
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH60390
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
2024-03-15
Closed date
2024-03-29
Last modified date
2024-05-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI96328
Modules/Macros
ADB2E ADB2EM1 ADB2EM2 ADB2EMM ADB2EMO ADB2EMS ADBE00 ADBE01 ADBEEM1 ADBEEM2 ADBEEMM ADBEEMO ADBHE ADBHEM1 ADBHEM2 ADBHEMM ADBHEMO ADBHEMS
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RD10 PSY UI96328
UP24/04/03 P F404
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:
02 May 2024