Home > IT Answers > DataCenter > EDM Pool Usage
Coolster01
5 pts.
 EDM Pool Usage
COBOL, DB2, EDM Pool
I have a Cobol program which calls another DB2 program which in return executes a procedure. And this call happens more than thousands time...so EDM Pool getting filled up with pages which shuts down the DB2. Can you suggest what needs to be done to minimize the EDM Pool issue.

Software/Hardware used:
ASKED: October 29, 2008  4:53 PM
UPDATED: August 5, 2009  8:09 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I don’t think the EDM pool will fill because of executing a procedure. Database descriptors and such go into the EDM pool. oh, DYNAMIC SQL CACHE might be the cause of filling the EDM pool. But DB2 should throw out the oldest SQL if he runs out of room in the pool. I am not sure that this is the root of your trouble.

Meandyou
 5,205 pts.