Managing buffer pools in a partitioned environment is practically the same as a single-partitioned database. If you wish, you can use the defaults and let DB2 create buffer pools in all partitions.
A multi-partitioned database can have partitions dedicated to specific functions. Let's say that we have a new POS database with the following architecture: one partition for Ad-Hoc Reporting and four for DSS, which makes five partitions.
In a partitioned database, a buffer pool is defined on all database partitions, unless database partition groups are specified when creating the buffer pool. In this example, we would create two partition groups—posp_ahr
and posp_dss
.