PK51732: EDM SNAPSHOT DOES NOT WORK CORRECTLY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Here is the summary of customer's problems.
  
  1. EDMPOOL snapshot sqlcache works for DB2 V8, V9, and DB2 V7
  with sqlcache in dataspace. But it does not work for DB2 V7
  with sqlcache in DBM1 address space.
  
  2. Display very long sql text is not correct, garbages in the
  middle of the text.
  
  3. For DB2 V9 authid is not correct (unicode related).
  
  4. ZEDD3 - SQL statement text is scrambled (related to UNICODE
  IFC IDs)
  
  Customer's problem has been recreated using current V410
  install.
  

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:
  Various problems related to EDMpool SQLcache snapshot
  1.Invalid authid in DB2 V9 SQLcache display
  2.Missing SQLcache data in DB2 V7
  
  PROBLEM CONCLUSION:
  1.Use authid from SQL stats data for all DB2 releases.
  2.Collect SQL stats using ifi interface for all DB2 releases.
  

Problem conclusion

• 1.Use authid from SQL stats data for all DB2 releases.
  2.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:

  UK30734

Modules/Macros

•    HKDB410J KDB410J  KD2RESCA KD2RESCD KD2RESCE
  KO2CIFIA KO2CIFIS KO2CIFI2 KO2CTH6A KO2CTH6S KO2CTH62 KO2EDDSH
  KO2EDD2H KO2OEDSB KO2OSORB KO2OZM2B KO2XSY2A KO2XSY2S KO2XSY22
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK30734

     UP07/11/08 P F711

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.