z/OS: DB2 9 EDMPOOL clarification

Olle Brostrom

z/OS: DB2 9 EDMPOOL clarification
Hello friends, I do not really understand the EDMPOOL in DB2 9. DB2 documentation and DB2 monitors does not correlate. In DB2 9 Parts of the traditional EDMPOOL (RDS) have been moved out. Installation Guide says: "The skeleton pool, which is located above the bar, is a component of EDM for storing skeleton cursor tables (SKCTs) and skeleton package tables (SKPTs)" Our Zparms are: EDMBFIT=NO, EDMDBDC=100000, EDMPOOL=132000, EDMSTMTC=100000, EDM_SKELETON_POOL=75000, Why are there 98.33% free in the traditional EDMPOOL, it looks like that we only need some 1000 pages in the EDMPOOL? Why are EDM_SKELETON_POOL=75000 allocated below bar when DB2 documentation says that the Skeleton Pool are allocated above the bar? Why are there 524287 pages allocated for "Skeleton Statement Pool Above" when almost nothing is used? Our DB2 monitor (Mainview for DB2) shows the EDM parts as follow: Storage Usage................. %Pool ÄPages EDM Pool...................... 33000 Free Pages.................. 98.33 32448 Non-Stealable............... 1.67 552 CT........................ 0.33 108 PT........................ 1.35 444 Stealable.................... SKCT........................ n/a n/a SKPT........................ n/a n/a DBD......................... n/a n/a Dynamic SQL Cache........... n/a n/a Dynamic SQL Cache - Data Space n/a Free........................ n/a n/a Used........................ n/a n/a Dyn SQL Cache Statement Pool.. 25000 Free........................ 85.64 21409 Used........................ 14.36 3591 Ä of Statements in Pool..... 517 . SQL Cache Details........... DBD Pool...................... 25000 Free........................ 86.54 21636 Used........................ 13.46 3364 DBD......................... 13.46 3364 Skeleton Statement Pool Below. 19192 Free........................ 33.40 6410 Used for CT................. 3.14 602 Used for PT................. 63.46 12180 Skeleton Statement Pool Above. 524287 Free........................ 99.95 524028 Used for CT................. 0.00 0 Used for PT................. 0.05 259 Activity...................... Interval Session Pool Full Failures............ EDM Pool.................. 0 0 Dynamic SQL Cache......... n/a n/a Statement Pool............ 0 0 DBD Pool.................. 0 0 Skeleton Below............ 0 0 Skeleton Above............ 0 0 CT: Requests................. 8994 574988 Loads.................... 225 6050 Hit Ratio................ 97.50 98.95 DBD: Requests................. 58452 3425052 Loads.................... 0 192 Hit Ratio................ 100.00 99.99 PT: Requests................. 388353 20449670 Loads.................... 3151 81042 Hit Ratio................ 99.19 99.60 I'm hoping for some interesting comments! Thanks, Olle

IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services

Olle Brostrom

Re: z/OS: DB2 9 EDMPOOL clarification
(in response to Olle Brostrom)
I resend the message with Plain text this time, Sorry!
Hello friends,
I do not really understand the EDMPOOL in DB2 9. DB2 documentation and DB2
monitors does not correlate.

In DB2 9 Parts of the traditional EDMPOOL (RDS) have been moved out.

Installation Guide says: "The skeleton pool, which is located above the bar, is
a component of EDM for storing skeleton cursor tables (SKCTs) and skeleton
package tables (SKPTs)"
Our Zparms are:
EDMBFIT=NO,
EDMDBDC=100000,
EDMPOOL=132000,
EDMSTMTC=100000,
EDM_SKELETON_POOL=75000,

Why are there 98.33% free in the traditional EDMPOOL, it looks like that we
only need some 1000 pages in the EDMPOOL?

Why are EDM_SKELETON_POOL=75000 allocated below bar when DB2
documentation says that the Skeleton Pool are allocated above the bar?

Why are there 524287 pages allocated for "Skeleton Statement Pool Above"
when almost nothing is used?

Our DB2 monitor (Mainview for DB2) shows the EDM parts as follow:
Storage Usage................. %Pool ÄPages
EDM Pool...................... 33000 (pending)
Free Pages.................. 98.33 32448
Non-Stealable............... 1.67 552
CT........................ 0.33 108
PT........................ 1.35 444
Stealable....................
SKCT........................ n/a n/a
SKPT........................ n/a n/a
DBD......................... n/a n/a
Dynamic SQL Cache........... n/a n/a

Dynamic SQL Cache - Data Space n/a
Free........................ n/a n/a
Used........................ n/a n/a

Dyn SQL Cache Statement Pool.. 25000
Free........................ 85.64 21409
Used........................ 14.36 3591
Ä of Statements in Pool..... 517
. SQL Cache Details...........

DBD Pool...................... 25000
Free........................ 86.54 21636
Used........................ 13.46 3364
DBD......................... 13.46 3364

Skeleton Statement Pool Below. 19192
Free........................ 33.40 6410
Used for CT................. 3.14 602
Used for PT................. 63.46 12180

Skeleton Statement Pool Above. 524287
Free........................ 99.95 524028
Used for CT................. 0.00 0
Used for PT................. 0.05 259

Activity...................... Interval Session

Pool Full Failures............
EDM Pool.................. 0 0
Dynamic SQL Cache......... n/a n/a
Statement Pool............ 0 0
DBD Pool.................. 0 0
Skeleton Below............ 0 0
Skeleton Above............ 0 0

CT: Requests................. 8994 574988
Loads.................... 225 6050
Hit Ratio................ 97.50 98.95
DBD: Requests................. 58452 3425052
Loads.................... 0 192
Hit Ratio................ 100.00 99.99
PT: Requests................. 388353 20449670
Loads.................... 3151 81042
Hit Ratio................ 99.19 99.60
I'm hoping for some interesting comments!
Thanks, Olle

______________________________________________________________________

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



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms