Question from rookie DB2 systems

Jeff Kinney

Question from rookie DB2 systems
I have a question that may be too general, Our DBA's wish to increase the
EDMPOOL size, which gives me a few questions...

What is the impact of increasing it?
Where is it located at? CSA, ECSA...?
If we go too big for the system what are some indications?

Thanks...

Signed.... just learning!


============
Jeffrey S. Kinney [login to unmask email]
Systems Programmer II Phone: (252) 328-9052
Fax: (252) 328-4258
East Carolina University
Information Technology and Computing Systems
Greenville, NC 27858
============



Nick Cianci

Re: Question from rookie DB2 systems
(in response to Jeff Kinney)
Jeff,
the EDM-pool is located in the <SSID>DBM1 address space,
consequently it, the BP (prior to BP Dataspaces), the sort pool, RID pool,
ands the code associated w/ the address space need to fit into the 2 G-byte
available. The implications of an EDM pool that is "too" big is that you
take space away from your buffer pool. The implication of having it too
small is that you get failures. The overall size of DBM1 may affect your
paging rate.

RTFM (or Read The Friendly Manual) Admin Guide Chapt 27 (in the V7 guide),
and note the comments on P.573 about EDM Pool space utilisation and
performance. In particular you will get a performance boost for pools over
40Meg. This is probably over kill for most systems that I've worked on, but
the impact on the BP's are generally negligible, and we have observed a
performance boost each time we've done it. Also pay attention to Sort and
RID Pool sizes The Admin guide has a good chat on them too; I've never seen
a good sort, but having enough space in the sort pool can save a little
anguish.

Cheers,
Nick F. Cianci
IBM Certified Solutions Expert
- DB2 UDB V7.1 Database Administration for OS/390

EDS Canberra Solution Centre
DB2 DataBase Administrator
Phone: +61 2) 6275-5863
+61 (0)408-64 06 01


-----Original Message-----
From: Kinney, Jeff [mailto:[login to unmask email]
Sent: Wednesday, 15 January 2003 6:24 AM
To: [login to unmask email]
Subject: Question from rookie DB2 systems


I have a question that may be too general, Our DBA's wish to increase the
EDMPOOL size, which gives me a few questions...

What is the impact of increasing it?
Where is it located at? CSA, ECSA...?
If we go too big for the system what are some indications?

Thanks...

Signed.... just learning!


============
Jeffrey S. Kinney [login to unmask email]
Systems Programmer II Phone: (252) 328-9052
Fax: (252) 328-4258
East Carolina University
Information Technology and Computing Systems
Greenville, NC 27858
============