Re: Question from rookie DB2 systems
January 14, 2003 03:52 PM
(in response to Jeff Kinney)
the EDM-pool is located in the <SSID>DBM1 address space,
consequently it, the BP (prior to BP Dataspaces), the sort pool,
ands the code associated w/ the address space need to fit into the
available. The implications of an EDM pool that is "too" big is
take space away from your buffer pool. The implication of having it
small is that you get failures. The overall size of DBM1 may affect
RTFM (or Read The Friendly Manual) Admin Guide Chapt 27 (in the V7
and note the comments on P.573 about EDM Pool space utilisation
performance. In particular you will get a performance boost for
40Meg. This is probably over kill for most systems that I've worked
the impact on the BP's are generally negligible, and we have
performance boost each time we've done it. Also pay attention to
RID Pool sizes The Admin guide has a good chat on them too; I've
a good sort, but having enough space in the sort pool can save a
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
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
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?
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