"Joe C" <rockets@joecool.org> wrote in message
news:3f1bf505.326374782@news1.attglobal.net...
> I am running DB2 6.1 in Windows 2000 server. I have 3872 meg of RAM
> and 8 databases. I keep getting the following two errors:
>
> "The memory for bufferpool and estore cannot be allocated: 0000 0800 "
> and
> "Database is starting up with 1 small buffer pools each of size 16
> pages".
>
> I have played around with the BUFFER POOL SIZE setting under
> PERFORMANCE and I have also tried to use the CONFIGURE USING
> SMARTGUIDE settings. But because I don't understand some basic things
> I haven't gotten rid of the errors yet. My questions are:
>
> 1. Under CONFIGURING USING SMARTGUIDE, where it asks for TARGET
> MEMORY, do I set that parameter for all databases or just the database
> I am configuring? I assume unless the server is only running DB2 and
> nothing else, that I would never set it to 100% and for 8 databaes it
> would be 12.5%?
>
> 2. Under CONFIGURE - PERFORMANCE, BUFFERPOOL SIZE, that BUFFERPOOL is
> only for that one database? So for 8 databases max buffer size would
> be 3872 meg/4096*8? Setting the value of buffpage to just 32000 per
> database (32000*4096*8 = 524 meg total) still gives me the same
> errors.
>
> Thanks for any insight on how to configure this system.
>
> Joe C.
>

1. Yes for 8 databases it would 12.5%. But you need to allow memory for
other DB2 processes, Operating system, etc. So the I would start with 60% /
12 = 5%.

2. Yes it is only for one database. But Windows 2000 cannot address 3872
megs of RAM. You can use extended storage for buffer pools, but not sure if
this is available in DB2 6.1. Check the manual more information on extended
storage for buffer pools.

3. You probably have too many databases. Maybe you should combine them if
they are being used simultaneously.