PK32486: VARIOUS INCORROUT PROBLEMS WITH DB2 V8 EDM POOL DISPLAY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• VARIOUS INCORROUT PROBLEMS WITH DB2 V8 EDM POOL DISPLAY
  
  1. Under V8 is that the EDM pool from V7 has been split into
     three sections, EDMDBDC, EDMPOOL & EDMSTMTC, each with a
     separate ZPARM controlling the maximum size.
  
     Pool Usage    Pages  Pct
     ----------- ------- ----
       In Use      36031  49%
         DBDs      35909  49%
         CTs          22   0%
         PTs         100   0%
       Available   37780  51%
         SKCTs        55   0%
         SKPTs     11765  16%
         SQL CACHE 25102  34%
       Free          858   1%
     Total Pages   73811 100%
  
     DBD in use is 35909 pages, or 140Mb. the DBD limit as defined
     by EDMDBDC is 149 Mb.  The percentage value is 49%.  The
     value should read 94% to be of any real use.  CTs, SCTs, PTs
     and SPTs are controlled by the EDMPOOL parameter and SQL
     CAHCE is controlled by the EDMSTMTC parameter in similar
     fashions.
  
     The % of DBD usage should be calculated using the DBD  pool,
     not the old EDM pool total
  
  2. EDM pool snapshot zoomed into DBDs lists off the DBDs in the
     EDM pool. The values for DBD length in this list does not
     match the values seen for DBD length when a DIS DB(xxx)
     command is issues.  Omeg DB2 varies in what is reported.
     Yesterday was 33Mb for one DBD (only 13Mb today) while a
     display DB command comes in at 8Mb.   Why is there this
     discrepancy?
  
  3. Failures due to EDM Pool full is 0, despite numerous resource
     unavailable messages e.g.
     TB2A DSNGEPUF RESOURCE UNAVAILABLE
     REASON 00C90089
     TYPE 00000602
     NAME EDM DBD SPACE
     Should these messages be driving this counter?
     Should for V8 should we have a counter for each section of
     the EDM
     pool?
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Classic Interface                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: VARIOUS INCORROUT PROBLEMS WITH         *
  *                      DB2 V8 EDM POOL                         *
  ****************************************************************
  * RECOMMENDATION: APPLY THIS PTF.                              *
  ****************************************************************
  1. UNDER V8 THE EDM POOL HAS BEEN SPLIT INTO THREE
  SECTIONS. BUT OMEGAMON DISPLAYS EDM POOL AS A SINGLE
  WHOLE ON ZEDMP PANEL:
  - PERCENT CALCULATIONS ARE WRONG;
  - FAILURES DUE TO EDM POOL FULL IS 0, DESPITE NUMEROUS
    RESOURCE UNAVAILBLE MESSAGES E.G.
      TB2A DSNGEPUF RESOURCE UNAVAILABLE
      REASON 00C90089
      TYPE 00000602
      NAME EDM DBD SPACE
  2. DBD SIZES ON ZEDSD PANEL ARE INVALID.
  

Problem conclusion

• ZEDMP PANEL IS RE-DESIGNED, OMEGAMON PROGRAMS ARE UPDATED
  TO DISPLAY DB2 VERSION 8 DATA CORRECTLY.
  
  KEYWORDS :INCORROUT EDM PERCENT FAILURES FULL DBD SIZE ZEDMP
            ZEDSD
  

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:

Modules/Macros

•    KD2REDMD KO2APCAA KO2APCAS KO2APCA2 KO2APCBA
  KO2APCBS KO2APCB2 KO2APC2A KO2APC2S KO2APC22 KO2CIFIA KO2CIFIS
  KO2CIFI2 KO2CSTSB KO2DNTHA KO2DNTHS KO2DNTH2 KO2DXS1A KO2DXS1S
  KO2DXS12 KO2EDMPH KO2HDTIB KO2NCSTB KO2OSTDB KO2OSTSB KO2OXSYB
  KO2WNCYB KO2XSYSA KO2XSYSS KO2XSYS2 KO2XSY2A KO2XSY2S KO2XSY22
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK19631

     UP06/11/17 P F611

• R410 PSY UK19655

     UP06/11/17 P F611

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.