Altering a buffer pool for a partitioned database

Use the Alter Buffer Pool window to modify the size of the buffer pool, add nodegroups, or specify how it uses extended storage.

Fields and controls

Authorities and privileges

To alter a buffer pool for a partitioned database:

1. Open the Alter Buffer Pool window.

2. You can perform the following tasks:

   • To specify that pages being migrated out of this buffer pool will be stored in extended storage, select the Use extended storage check box.

   • If the Select nodes by nodegroups radio button is preselected, you can add selected nodegroups to the list of nodegroups to which the buffer pool definition applies. Click on the arrow push buttons to move the selected nodegroups between the Available nodegroups and Selected nodegroups boxes. (You cannot remove nodegroups that were used to create the buffer pool.)

   • To modify the default size of the buffer pool on selected nodes, select the nodes in the Change size of buffer pool by node box, and then type the new size in the Size in pages field.

3. Click on OK to alter the buffer pool characteristics.