Hi,

I try to create a tablespace like this:

create tablespace tb01 pagesize 16k managed by database
using
(
FILE 'c:\ct\0\tb01.dbf' 300,
FILE 'c:\ct\1\tb01.dbf' 300

) extentsize 16 prefetchsize 8
bufferpool buff16;

before I have already creating a bufferpool like this:
create bufferpool buff16 size 20 pagesize 16k
alter bufferpool buff16 extended storage

and I have this error message, when I try to create the tablespace tb01:
SQL0647N: the bufferpool "buff16" is not active

How can I activate a bufferpool?
Thanks

Stop and restart the database; after that, your bufferpool should be active.

Rhino

"Ouizzze" <ouizzze@voila.fr> wrote in message
news:ca94e4e7.0307170730.2b5658a0@posting.google.c om...
> Hi,
>
> I try to create a tablespace like this:
>
> create tablespace tb01 pagesize 16k managed by database
> using
> (
> FILE 'c:\ct\0\tb01.dbf' 300,
> FILE 'c:\ct\1\tb01.dbf' 300
>
> ) extentsize 16 prefetchsize 8
> bufferpool buff16;
>
> before I have already creating a bufferpool like this:
> create bufferpool buff16 size 20 pagesize 16k
> alter bufferpool buff16 extended storage
>
> and I have this error message, when I try to create the tablespace tb01:
> SQL0647N: the bufferpool "buff16" is not active
>
> How can I activate a bufferpool?
> Thanks

deactivate/activate the database

"Ouizzze" <ouizzze@voila.fr> wrote in message
news:ca94e4e7.0307170730.2b5658a0@posting.google.c om...
> Hi,
>
> I try to create a tablespace like this:
>
> create tablespace tb01 pagesize 16k managed by database
> using
> (
> FILE 'c:\ct\0\tb01.dbf' 300,
> FILE 'c:\ct\1\tb01.dbf' 300
>
> ) extentsize 16 prefetchsize 8
> bufferpool buff16;
>
> before I have already creating a bufferpool like this:
> create bufferpool buff16 size 20 pagesize 16k
> alter bufferpool buff16 extended storage
>
> and I have this error message, when I try to create the tablespace tb01:
> SQL0647N: the bufferpool "buff16" is not active
>
> How can I activate a bufferpool?
> Thanks

"Ouizzze" <ouizzze@voila.fr> wrote in message
news:ca94e4e7.0307170730.2b5658a0@posting.google.c om...
> Hi,
>
> I try to create a tablespace like this:
>
> create tablespace tb01 pagesize 16k managed by database
> using
> (
> FILE 'c:\ct\0\tb01.dbf' 300,
> FILE 'c:\ct\1\tb01.dbf' 300
>
> ) extentsize 16 prefetchsize 8
> bufferpool buff16;
>
> before I have already creating a bufferpool like this:
> create bufferpool buff16 size 20 pagesize 16k
> alter bufferpool buff16 extended storage
>
> and I have this error message, when I try to create the tablespace tb01:
> SQL0647N: the bufferpool "buff16" is not active
>
> How can I activate a bufferpool?
> Thanks

In addition to what the others have said, do you know that the Buffer Pool
is defined in number of "pages," so that your bufferpool is 320 KB (about
1/3 of a MB). This is "probably" way too small.

Thank's, it's ok.
I have another question. How can you determine the size of a bufferpool?
In this exemple, it's 20*16=320k. Why it seems too small?

"Ouizzze" <ouizzze@voila.fr> wrote in message
news:ca94e4e7.0307180358.751f519d@posting.google.c om...
> Thank's, it's ok.
> I have another question. How can you determine the size of a bufferpool?
> In this exemple, it's 20*16=320k. Why it seems too small?

Bufferpool size is one of the most important performance parameters in DB2.
It determines how much memory DB2 uses for data and index pages. DB2 uses
bufferpools to avoid synchronous I/O to disk, sort of like a sophisticated
disk cache.

I suspect that the 16K bufferpool is not the only one active. However, the
sum of all buffer pools active at any one time should probably utilize at
least one half of the total system memory on the machine. The amount
assigned to DB2 bufferpools depends on what other activity the machine
performs and the memory available. Any time a database connection is made,
all the bufferpools for that database are active. The default size of the 4K
default bufferpool is probably also too low.

Mark
InfoStar Solutions, LLC

Courious as to why you pick prefetchsize 8 with an extentsize of 16 ?
Prefetch should be minimum 1:1 with extentsize, and possible scaled to
a multiple of number of physical disk containers.

Powell.


ouizzze@voila.fr (Ouizzze) wrote in message news:<ca94e4e7.0307170730.2b5658a0@posting.google. com>...
> Hi,
>
> I try to create a tablespace like this:
>
> create tablespace tb01 pagesize 16k managed by database
> using
> (
> FILE 'c:\ct\0\tb01.dbf' 300,
> FILE 'c:\ct\1\tb01.dbf' 300
>
> ) extentsize 16 prefetchsize 8
> bufferpool buff16;
>
> before I have already creating a bufferpool like this:
> create bufferpool buff16 size 20 pagesize 16k
> alter bufferpool buff16 extended storage
>
> and I have this error message, when I try to create the tablespace tb01:
> SQL0647N: the bufferpool "buff16" is not active
>
> How can I activate a bufferpool?
> Thanks