Table Space size and Bufferpool page size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raja Shekar - 29 Dec 2005 06:30 GMT

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

Reply to this Message

Pierre Saint-Jacques - 29 Dec 2005 18:10 GMT

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.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> HI Every body ,
> I would like to know whether is it mandatory to give Tablespace page
[quoted text clipped - 5 lines]
> Thanks in Advance
> Raja Shekar

Reply to this Message