PH64869: SQL PERFORMANCE ANALYZER ENHANCEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Support of Db2 managed vs ESM managed security, remove some
  obsolete parameters, update Tools Customizer Discovery functions
  with the latest parameters.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 SQL Performance Analyzer        *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1. Move grant authorization objects to the separate file in TCz.
  2. Minimum threshold for CPUTIME flag on the panel
  'Query Limits Report' was changed.
  3. CLIST alignment for Query monitor to call SQL PA.
  4. Updates in TCz for function Discover and user parameter
  CPUTIME.
  5. Update Admin_Explain_Maint to Use "Owner" Instead of SQL ID.
  

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:

  UO02707

Modules/Macros

• ANL$$PRM ANL$$SEQ ANL00    ANLBATCH ANLBNDGR ANLBNPLA ANLBNSGR
  ANLCDISC ANLCIGO  ANLCKTBL ANLCLOB  ANLCSV   ANLDB2X  ANLDBADM
  ANLDCRE8 ANLDPRM  ANLEEE   ANLGPRM  ANLGPST  ANLICRE8 ANLJCRE8
  ANLMAIN  ANLPADMN ANLPH83A ANLPH83B ANLPH83C ANLPH83D ANLPH83E
  ANLPHA31 ANLPHS01 ANLPICP  ANLPIDD  ANLPIQLR ANLPITP  ANLPLAN
  ANLPPRMS ANLPPRMU ANLPTCM  ANLPTEX  ANLPTLD  ANLPTRP  ANLPTSM
  ANLPUOPT ANLSERV  ANLSQ2M  ANLSQLPA ANLTABS  ANLTOHEX ANLTSO
  ANLVER8  ANLWLMSP
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R520 PSY UO02707

     UP25/04/05 P F504

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.