PK51318: SLOW PERFORMANCE ON DYNAMIC CACHE PANEL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Poor performance when viewing Dynamic Cache
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Classic Interface                        *
  *                 -   CUA Interface                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrout from EDM Pool SQL cache       *
  *                      snapshot                                *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  1.Slow performance getting EDMPool SQLcache snapshot
  2.Invalid authid in SQLcache display
  3.Missing SQLcache data in DB2 V7
  
  PROBLEM CONCLUSION:
  1.Retrieve full SQL text at EDD3 display. Use 60 bytes sql text
  from statistics to improve performance
  2. Use authid from SQL stats data for all DB2 releases
  3. Collect SQL stats using ifi interface for all DB2 releases
  

Problem conclusion

• 1.Retrieve full SQL text at EDD3 display. Use 60 bytes sql text
  from statistics to improve performance
  2. Use authid from SQL stats data for all DB2 releases
  3. Collect SQL stats using ifi interface for all DB2 releases
  KEYWORDS :
  INCORROUT EDDS EDDT EDD2 EDD3 EDMPOOL SNAPSHOT SQLCACHE SLOW
  PERFORMANCE AUTHID ZSQL KD2RESCD
  

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:

  UK33295

Modules/Macros

• HKDB310J KDB310J  KD2RESCA KD2RESCD KD2RESCE
  KO2CCISS KO2CCIS2 KO2CIFIS KO2CIFI2 KO2CTHIS KO2CTHI2 KO2EDDSH
  KO2EDD2H KO2EDD3H KO2OEDSB KO2OSORB KO2OSUBB KO2OZM2B KO2XDDSB
  KO2XRCTT KO2XRCTU KO2XRCTV KO2XRCTW KO2XRCT3 KO2XSY2S KO2XSY22
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK33295

     UP08/02/04 P F802

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.