EDM POOL FULL condition after migrating to V8 NFM

Renzo Razzetti

EDM POOL FULL condition after migrating to V8 NFM
hello everybody !

I'm running DB2 V8 NFM, Cobol LOCAL applications in datasharing enviorment.
Not dynamic application are running, not distributed application is running,
not storage procedure is running.



I have received this error in production. 66 times in the 1 second interval.
And the application canceled with RC -904 resource unavailable.

16.22.44 STC28433 DSNT500I -DP21 DSNGEPLC RESOURCE UNAVAILABLE 004
004 REASON 00C90089
004 TYPE 00000600
004 NAME EDM POOL SPACE
...................................
16.22.45 STC28433 DSNT500I -DP21 DSNGEPLC RESOURCE UNAVAILABLE 013
013 REASON 00C90089
013 TYPE 00000600


If we look in the statistic report the EDM Pool for 15 interval during
16:15 to 16:30, we can see only the 40% of the pages are in use. It looks
the EDM Pool is not full.
Can any help to understand what is the problem ? How I can find the problem
?
Thank you.


EDM POOL QUANTITY /SECOND /THREAD /COMMIT
--------------------------- -------- ------- ------- -------
PAGES IN EDM POOL (BELOW) 37500.00 N/A N/A N/A
HELD BY CT 208.86 N/A N/A N/A
HELD BY PT 6682.08 N/A N/A N/A
HELD BY SKCT 9.79 N/A N/A N/A
HELD BY SKPT 9193.57 N/A N/A N/A
FREE PAGES 21405.71 N/A N/A N/A
% PAGES IN USE 42.92 N/A N/A N/A
% NON STEAL. PAGES IN USE 18.38 N/A N/A N/A
FAILS DUE TO POOL FULL 66.00 0.08 0.00 0.00

PAGES IN DBD POOL (ABOVE) 20000.00 N/A N/A N/A
HELD BY DBD 7632.00 N/A N/A N/A
FREE PAGES 12368.00 N/A N/A N/A
FAILS DUE TO DBD POOL FULL 0.00 0.00 0.00 0.00

PAGES IN STMT POOL (ABOVE) 20000.00 N/A N/A N/A
HELD BY STATEMENTS 18916.21 N/A N/A N/A
FREE PAGES 1083.79 N/A N/A N/A
FAILS DUE TO STMT POOL FULL 0.00 0.00 0.00 0.00

DBD REQUESTS 70916.00 83.29 1.01 0.38
DBD NOT FOUND 0.00 0.00 0.00 0.00
DBD HIT RATIO (%) 100.00 N/A N/A N/A
CT REQUESTS 70178.00 82.42 1.00 0.38
CT NOT FOUND 11.00 0.01 0.00 0.00
CT HIT RATIO (%) 99.98 N/A N/A N/A
PT REQUESTS 3385.0K 3975.56 48.22 18.18
PT NOT FOUND 3592.00 4.22 0.05 0.02
PT HIT RATIO (%) 99.89 N/A N/A N/A

PKG SEARCH NOT FOUND 4018.8K 4719.88 57.25 21.58
PKG SEARCH NOT FOUND INSERT 3040.00 3.57 0.04 0.02
PKG SEARCH NOT FOUND DELETE 3041.00 3.57 0.04 0.02

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html