By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,905 Members | 902 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,905 IT Pros & Developers. It's quick & easy.

Table Space size and Bufferpool page size

P: n/a
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

Dec 29 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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***********@gmail.com> a écrit dans le message de news:
11*********************@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


Dec 29 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.