PK80763: EDM POOL SNAPSHOT PROBLEM

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• EDM POOL SNAPSHOT PROBLEM
  
  From classical view.
  R.C.A
  you get to the EDM POOL SNAPSHOT SUMMARY - ZEDSN panel.
  here the very first error:
  << The following EDM snapshot was collected on 12/22/08 at
  12:08:06. >>
  << Please recollect snapshot data
  << To redrive EDM collection place a '-' in column one of the
  command. >
  << To redrive on ENTER key basis place a '<' in column one of
  the cmd. >
  .
  Even if we recollect the EDM snapshot this message continues to
  appear.
  Zooming on SQL cache (PF11) you geto to ZEDDS panel.
  we keep on having the msg: + <<< Please recollect snapshot data
  and the
  'pages alloc' column shows all zeros.
  .
  Going further, zooming on any Authid you get to panel ZEDD2:
  under the column 'pages' you get always N/A.
  .
  Furthermore sometimes zooming on an instraction you get to panel
  ZEDD3
  with al dots:
  .
  __________  ZEDD3    VTM LOG O2       V410.DM DBAG 12/22/08
  11:44:21   2
  >.LOGPOP   >> LOG STATUS RESTORED TO INACTIVE. <<
  >.LOC                                                         >>
  DONE <<
  >  HELP PF1        BACK PF3         UP PF7         DOWN PF8
  >
  
  .
  > A-SQL PA
  
  .
  ================================================================
  ========
  >               EDM SNAPSHOT DYNAMIC SQL CACHE STATISTICS
  >   STATISTICS REQUIRE THAT MONITOR CLASS 1 AND IFCID 318 BE
  STARTED
   EDD3
  +             AUTHORIZATION ID: APAN09
  +
  +
  ................................................................
  .....
  +  ....................................
  +
  +  TIMES EXECUTED                0   SYNCHRONOUS BUFFER READS
  0
  +  GETPAGES                      0   ROWS EXAMINED
  0
  .
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Classic Interface                        *
  *                 -   CUA Interface                            *
  ****************************************************************
  
  * PROBLEM DESCRIPTION: 1. Dots displayed on EDMPool snapshot   *
  *                         ZEDD3 panel                          *
  *                      2. Slow performance in DB2 V9 edmpool   *
  *                         snapshot collection                  *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  1. When sqltext is not available from EDMPool statement cache,
     dots displayed on ZEDD3 panel instead of SQL text.
  2.Wrong offset is used in DB2 V9 EDMPool snapshot collection
  
  PROBLEM CONCLUSION:
  1. Detect no SQL text from statement cache, display a message
     instead of unreadable dots.
  2. Use the correct DB2 V9 offset for EDMPool snapshot collection
  

Problem conclusion

• 1. Detect no SQL text from statement cache, display a message
     instead of unreadable dots.
  2. Use the correct DB2 V9 offset for EDMPool snapshot collection
  
  KEYWORDS : SQL STATEMENT CACHE DOTS
  

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:

  UK45852

Modules/Macros

• KO2OEDSB KO2OZM2B KO2XSY2A KO2XSY2S KO2XSY22
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK45852

     UP09/04/23 P F904

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.