SEO

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.

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

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