470,580 Members | 2,213 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,580 developers. It's quick & easy.

Table Space size and Bufferpool page size

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

Similar topics

10 posts views Thread by Bing Wu | last post: by
4 posts views Thread by Jeff | last post: by
1 post views Thread by Christian Berg | last post: by
10 posts views Thread by Hemant Shah | last post: by
6 posts views Thread by gimme_this_gimme_that | last post: by
2 posts views Thread by rAinDeEr | last post: by
6 posts views Thread by pravin.prabhakar | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.