PH37404: IMPROVE ACCESS TO EXISTING EXPLAIN INFORMATION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Provide an easy way to pull existing explain information for a
  particular version of a package or collection.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Db2 SQL Performance Analyzer             *
  *                 users of components                          *
  *                 - ISPF  Process packages from the DB2        *
  *                   system catalog                             *
  *                 - BATCH TEST                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: New Functions                           *
  *                      1. Improve access to existing explain   *
  *                      information,                            *
  *                      2."Idea"  DB2ZSQLPA-I-9 -  Retain       *
  *                      relevant fields coming from ANLPFILE.   *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  New Function. See Description.
  

Problem conclusion

• Code was added to implement the enhancements.
  

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:

  UI76365

Modules/Macros

• ANLCMIGR ANLH11   ANLH12   ANLJB003 ANLMAIN  ANLPDBRM ANLPFILE
  ANLPH115 ANLPPKGE ANLPSELC ANLPSELV ANLSQLPA ANLTSO
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UI76365

     UP21/07/22 P F107

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.