jc******@yahoo.com wrote:
Knut,
Thanks for the reply. I was trying to get away with only using one
bufferpool - while dedicating as much memory to my data partitions - I
did not want the catalog partition to get the memory that it will never
consume.
I thought of just creating a single partition bufferpool in Partion 0,
but that causes a problem for tempspace. Temprory tablespaces belong
to IBMTEMPGROUP which exists across all partitions. So, I still need a
bufferpool (for tempspace) that will span all partitions.
It appears that my best option would be to keep the single BP, minimize
the size on Partition 0, and minimize the size of the NUMBLOCKPAGES
area in all Partitions.
Thanks..John
John,
It is a lot easier to manage if you create separate bufferpools --
assuming you have a nodegroup that encompasses your 4 data partitions,
create the bufferpool for the nodegroup that needs it.
The ability to change bufferpool sizes per partition is convenient
in situations where it's necessary (i.e. different servers have
differing amounts of real memory), but it makes managing things
more complicated in the future.