Managing buffer pools in a multipartitioned database

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.

Getting ready

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.

How to do it...

1. Create partition groups.

   In this example, we will create two partition groups:

   posp_ahr:
   [db2instp@nodedb21 ~]$ db2 "create database partition group posp_ahr on dbpartitionnums (0)"
   DB20000I  The SQL command completed successfully.posp_dss:
   [db2instp@nodedb21...