PH68774: SQL PERFORMANCE ANALYZER ENHANCEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Enhancements for stabilized dynamic queries
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 SQL Performance Analyzer        *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Improved usability of SQL PA functions:
  Process packages from the DB2 system catalog - Added a new field
   on the Collection ID prompt panel and introduced a new Explain
  option, direct access to TEST function.
  Process stabilized dynamic queries - Added new prompt panels.
  

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:

  UO06409

Modules/Macros

• ANL05    ANLEEE   ANLH09   ANLH11   ANLMAIN  ANLPDYNE ANLPH200
  ANLPHB10 ANLPHB1A ANLPHG00 ANLPHG11 ANLPMAN1 ANLPPKGE ANLPSDQ
  ANLPSDQM ANLPSELC ANLPSELS ANLPTTST ANLSQLPA ANLTSO
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R520 PSY UO06409

     UP26/01/13 P F601

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.