EDM POOL CONCERN

William Favero

EDM POOL CONCERN
If your dynamic state cache is defined in a dataspace, it will not have
an affect on your EDM pool.

However, KEEPDYNAMIC YES in conjunction with MAXKEEPD will affect the
DBM1 address space storage utilization. I would suggest taking a look
at John Campbell's presentation on storage management or giving his
webcast on storage management a listen.

Presentation URL
http://www.ibm.com/support/docview.wss?rs=64&context=SSEPEK&q1=campbell&uid=swg27006985&loc=en_US&cs=utf-8&lang=en
Tiny URL - http://tinyurl.com/bsty8

Webcast replay information is in my blog entry -
http://blogs.ittoolbox.com/database/db2zos/archives/006846.asp

Willie

My DB2 blog --> http://blogs.ittoolbox.com/database/db2zos



Ken Hynes wrote:

>Hi,
>
> Appreciate the feedback on the EDMPOOL concerns. Per Wille, I do
>have 30000 pages allocated to Dynamic Cache and I know it's being utilized.
>What prompted the question and concern was that this system apparently uses
>a significant amount of KEEPDYNAMIC(YES) which according to the
>Applications Programming guide caches the Prepare "Locally" -- the SQL
>String would go to the Data Space Dynamic Cache. Sorry, I should have
>included that in the original "Post". Per the DOC: "When the dynamic
>statement cache is active, and you run an application bound with KEEPDYNAMIC
>(YES), DB2 retains a copy of both the prepared statement and the statement
>string." I am happy overall with the Hit Ratios as mentioned by Chris White
>and perhaps I am being a bit "too careful" in trying to get a larger "Free
>Shelf" in the Pool. There has been discussion of adding some new
>Applications and files to the system which was why I was looking to
>increase the Free Space. I am also wondering if the MAXKEEPD parm (set at
>5000) is too high as STATS reports show "0" statements Discarded. We
>increased the Pool by about 10% recently and went from 3% Free at MAx
>Allocation to 7% Free -- so "Something" likes the new storage. Again, we
>don't have a "Problem" and I appreciate the feedback. It "Aint Broke" as
>Chris and WIllie point out so maybe move on to a more "immediate" problem.
>
> Thanks.....Ken Hynes
>
>---------------------------------------------------------------------------------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
>
>
>


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm