V8 CMP EDM Pool

5 pts.
Tags:
CICS
EDM Pool
IBM DB2
SQL
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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?

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: