5 pts.
 V8 CMP EDM Pool
Strobe shows very high CPU in Module DSNGEDM Sections DSNGECMP & DSNGEPUF (which free expanded EDM Pool Storage) for dynamic SQL in a CICS Region. Is this an EDM Pool sizing issue?

Software/Hardware used:
ASKED: June 5, 2008  7:43 PM
UPDATED: June 25, 2008  9:46 PM

Answer Wiki:
Dear Winger, EDM Pool sizing issues show up as excessive I/O due to paging. High CPU usage does not necessarily mean that you have a space problem, it may simply mean that alot is going on. The EDM pool is used for caching internal structures used by DB2 programs. This includes DBDs, SKCTs, CTs, SKPTs, and PTs. It also includes the authorization cache for plans and packages, as well as the cache for dynamic SQL mini-plans. As a general rule, you should shoot for an 80 percent hit rate with the EDM pool; this means that only one out every five times should a structure need to be loaded from disk into the EDM pool. What other tools do you use to monitor DB2 Resources?
Last Wiki Answer Submitted:  June 25, 2008  9:46 pm  by  Msenatore@fisa   185 pts.
All Answer Wiki Contributors:  Msenatore@fisa   185 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _