EDM pool failures
The EDM pool stores cursor tables (CT), package tables (PT), and database descriptors (DBD).
Any pool full failures (FAILS DUE TO POOL FULL
)
indicate that the EDM pool is too small for the DB2 workload. The
EDM pool should be big enough to store the cursor tables (CT), package
tables (PT), and database descriptors (DBD). The ratios CT
REQUESTS/CT NOT IN EDM
, PT REQUESTS/CT NOT IN EDM
,
and DBD REQUESTS/CT NOT IN EDM
show the EDM pool
utilization. Generally, ratios of about 80% are adequate in most cases.
If these values are significantly lower, reduce the size of the EDM
pool and allocate the saved storage to the buffer pool, where the
performance benefits are greater.