PK71709: INVALID ENTRY IN ZEDDS PANEL AND ERROR MESSAGES ON ZEDSN AND ZEDMP PANELS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following problems are seen:
  1. Invalid entry on ZEDDS panel:
                DYNAMIC SQL CACHE BY AUTHID
       Auth id     Entries   Pages Alloc    Bytes Used
   --------    -------   -----------    ----------
   ...           13353        0        -2147M
  *
  2.   On ZEDSN panel, message:
        Size calc for EDM snapshot failed
  *
  3.  On ZEDMP panel,message:
      System Wide Edmp Statistics Not Available
  *
  4. EDD2 panel >> OB0920: Command Loop - Recovery Successful <<
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   OMEGAMON collector                       *
  *                 -   PE Server subtask                        *
  *                 -   Classic Interface                        *
  *                 -   CUA Interface                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Invalid entry on ZEDDS panel:        *
  *                         DYNAMIC SQL CACHE BY AUTHID          *
  *                         Auth id     Entries   Pages Alloc    *
  *                         --------    -------   -----------    *
  *                         ...           13353        0         *
  *                                                              *
  *                      2. On ZEDSN panel, message:             *
  *                         Size calc for EDM snapshot failed    *
  *                                                              *
  *                      3. On ZEDMP panel,message:              *
  *                         System Wide Edmp Statistics Not      *
  *                         Available                            *
  *                                                              *
  *                      4. EDD2 panel >> OB0920: Command Loop   *
  *                         - Recovery Successful <<             *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  1. Invalid entry on ZEDDS panel:
     DYNAMIC SQL CACHE BY AUTHID
     Auth id     Entries   Pages Alloc
     --------    -------   -----------
     ...           13353        0
  
  2. On ZEDSN panel, message:
     Size calc for EDM snapshot failed
  
  3. On ZEDMP panel,message:
     System Wide Edmp Statistics Not
     Available
  
  4. EDD2 panel >> OB0920: Command Loop
     - Recovery Successful <<
  
  PROBLEM CONCLUSION:
  Processing and parsing of EDM Pool/Dynamic Statement Cache has
  been corrected and improved for response time.
  

Problem conclusion

• Processing and parsing of EDM Pool/Dynamic Statement Cache has
  been corrected and improved for response time.
  
  KEYWORDS :    ZEDMP ZEDSN EDD2 ZEDDS AUTHID
  

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:

  UK40507

Modules/Macros

•    DGOVDB2C DGOVISI  DGOVMSTR FPE@DB2I FPEVDB2I
  KD2VDTDD KD2VTHD6 KO2CCAFB KO2CDFSA KO2CDFSS KO2CDFS2 KO2CIFIA
  KO2CIFIS KO2CIFI2 KO2CTHFA KO2CTHFS KO2CTHF2 KO2CTHIA KO2CTHIS
  KO2CTHI2 KO2DISTH KO2FILTH KO2OSTDB KO2OTHBB KO2OTHDB KO2OTHQB
  KO2OTH3B KO2OTH5B KO2OTH8B KO2OTH9B KO2TOBJH KO2XSY2A KO2XSY2S
  KO2XSY22 KO2ZLOCH
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK40507

     UP08/10/08 P F810

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.