Thanks for your input. I was still getting errors with those changes
so I ran the select * from sysibm.sysbufferpools to see what npage was
and it was not = -1 so I guess the bufferpool parameter wasn't being
used. So I ran a query to set the buffer size to -1 so that the
bufferpool parameter worked and set it to 32000 and I also at the same
time set IBMDEFAULTPB to 32000. Now all errors have gone away and
everything seems to be working.

I sure wish that was a good book out there written just for DB2 admins
showing them how to set and configure each of those parameters.

Joe C.

On Mon, 21 Jul 2003 14:50:27 -0600, "Mark A" <ma@switchboard.net>
wrote:

>
>"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.
>
>
>