PH60390: ENHANCE EXPLAIN TABLE MAINTENANCE

Obtain the fix for this APAR.

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 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.