PM20795: SQL CACHE ZEDSN EDM POOL SNAPSHOT SUMMARY N/A

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• On SNAPSHOT HISTORY SUMMARY panel ZEDSN the SQL CACHE fields
  display the invalid characters "N/A"
  PTF BUILD IS 10.070 15:39:40
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 -   Classic Interface                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.SQL CACHE ZEDSN EDM POOL SNAPSHOT     *
  *                      SUMMARY N/A.                            *
  *                      2.Message "No Utility Information       *
  *                      Collected" for OMPE v410 command UTIL.  *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  1.DB2 V8, V9 offsets' changes could cause to N/A values for SQL
  CACHE fields 'Count of Entries', 'Avg Pages Entry' and 'Max
  Pages Entry' on panel ZEDSN(EDM POOL SNAPSHOT SUMMARY).
  2.In OMPE v410 command UTIL does not work and displays message
  "No Utility Information Collected".
  
  PROBLEM CONCLUSION:
  1.Use the correct V8, V9 offsets to collect SQL CACHE data
  correctly for EDM POOL SNAPSHOT SUMMARY.
  2.The processing of UTIL command was corrected.
  

Problem conclusion

• 1.Use the correct V8, V9 offsets to collect SQL CACHE data
  correctly for EDM POOL SNAPSHOT SUMMARY.
  2.The processing of UTIL command was corrected.
  
  KEYWORDS : SQL CACHE EDM POOL SNAPSHOT SUMMARY UTIL
  

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:

  UK60987 UK60988

Modules/Macros

• KO2ACAPA KO2ACAPS KO2ACAP2 KO2ED01A KO2ED01T
  KO2ED01W KO2ED013 KO2EOJSA KO2EOJSS KO2EOJS2 KO2OEDSB KO2XLKDA
  KO2XLKDS KO2XLKD2 KO2XSYSA KO2XSYSS KO2XSYS2 KO2XSY2A KO2XSY2S
  KO2XSY22 KO2XTHSA KO2XTHSS KO2XTHS2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK60987

     UP10/10/08 P F010

• R420 PSY UK60988

     UP10/10/08 P F010

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.