EDM POOL FULL condition after migrating to V8 NFM : more data

Renzo Razzetti

EDM POOL FULL condition after migrating to V8 NFM : more data
Hello,

I m adding more data in my question to see whether there is someone in the
list can help me.
Following is the statistic from 1 minute interval. The EDM Pool is always
around 40% used, but suddenly the PAGES of PT increase almost to 97% of the
EDM Pool.
I want to find the root cause of the problem, to avoid happen other time.
I'm already checked the number of transaction in CICS and the number of
thread in DB2 and they are not increase.

Could be this a bug in the EDM pool DB2 v8 ?

I will appreciate any suggestion to further analysis this problem.

RR



EDM POOL DP21 16:20 16:21 16:22 16:21 16:21 16:22 16:23
16:27 Elapsed
time
1 1 1 6 PAGES IN EDM POOL (BELOW)
37500 37500 37500 37500 HELD BY CT 176 290.42 588 234.67
HELD BY PT 4936 13113.24 34380 8780.87 HELD BY SKCT
9 8.17 6 10.17 HELD BY SKPT 11415 8716.93
1700 7322.49 FREE PAGES 20964 15371.24 826 21151.81 %
PAGES IN USE 44.1 59.01 97.8 43.6 % NON STEAL. PAGES IN USE
13.63 35.74 93.25 24.04 FAILS DUE TO POOL FULL 0 0 0 66































































On Sun, Jan 4, 2009 at 10:43 AM, Renzo razzetti <[login to unmask email]>
wrote:
>
> 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 Melbourne, Australia * 18-20 March * 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