Assigning page sets to group buffer pools

Any data sharing group can have up to fifty 4 KB page size group buffer pools. Each group can have up to ten each of 8 KB, 16 KB, and 32 KB page size group buffer pools.

About this task

Different group buffer pools can reside in different coupling facilities. The strict naming convention ensures that Db2 can map the group buffer pools to the individual member buffer pools. For example, buffer pool BP0 maps to group buffer pool GBP0. Thus, your choice of buffer pool determines which group buffer pool is used. GBP0 is the default unless you have specified a different default for user data and indexes on installation panel DSNTIP1.

Procedure

To assign a table space to a group buffer pool:

  1. Stop all access to the table space by issuing the STOP DATABASE command.
  2. Change the buffer pool assignment by running the ALTER TABLESPACE SQL statement.
  3. Allow access to the table space by issuing the START DATABASE command.

Example

The following example procedure shows how to assign table space DSN8S13D to GBP2. The procedure works only for altering a table space to a buffer pool that has the same page size.

  1. Stop all access to the table space by issuing the following command:
    -DB1A STOP DATABASE(DSN8D13A) SPACENAM(DSN8S13D)
  2. Change the buffer pool assignment by running the following SQL statement:
    ALTER TABLESPACE DSN8D13A.DSN8S13D
 BUFFERPOOL BP2;
  3. Allow access to the table space by issuing the following command: 
    -DB1A START DATABASE(DSN8D13A) SPACENAM(DSN8S13D)