HI Every body ,
I would like to know whether is it mandatory to give Tablespace page
size and Bufferpool page size equal..? i also heard like while creating
tablespace if pages size of tablespace and bufferpool , the statement
itself will fail ...why i'm asking is if we chose a different page size
( ofcourse less than bufferpool page size ) only it shoud affect the
performance of db2 ..
Thanks in Advance
Raja Shekar

Every tablespace of page size X must have a bufferpool of same page size.
Also there has to be at least one system temporay tablespace of page size X.
They can share the same bufferpool but for performance you should have a
bufferpool just for the temp space.

You heard right. If you have a tablespace of 8k page size and try to assign
a bufferpool of different size you create or alter tablespace should fail.
It does not only affect performance. It is required by the architecture
relationship of tablespace to buffer pools.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Raja Shekar" <ch.rajashekar@gmail.com> a écrit dans le message de news:
1135837837.593544.36030@g44g2000cwa.googlegroups.c om...
> HI Every body ,
> I would like to know whether is it mandatory to give Tablespace page
> size and Bufferpool page size equal..? i also heard like while creating
> tablespace if pages size of tablespace and bufferpool , the statement
> itself will fail ...why i'm asking is if we chose a different page size
> ( ofcourse less than bufferpool page size ) only it shoud affect the
> performance of db2 ..
> Thanks in Advance
> Raja Shekar
>