Alter Buffer Pool -- Fields and controls

Use the Alter Buffer Pool window to change the characteristics of an existing buffer pool.

Fields and controls

Buffer pool name

Page size

Use extended storage

Select all nodes

Select nodes by nodegroups

Change size of buffer pool by node

>>, >, <, <<

OK

Show SQL

Cancel

Buffer pool name

This field displays the name currently specified for the buffer pool that you're altering. You cannot alter the buffer pool name.

To alter another buffer pool instead of the one you selected, click on Cancel to return to the Control Center and select another buffer pool.

Page size

This box contains the size of the pages used for the buffer pool. The valid values are 4KB, 8KB, 16KB, and 32KB. The default is a 4KB page size. Using a larger page size allows you to create a table space with the same page size.

The page size of a table space must be the same as the page size of the buffer pool associated with the table space. If a long table space is defined then the page size must be 4KB.

You cannot alter the page size.

Use extended storage

Note:

The Use extended storage check box only applies to UNIX systems.

Select this check box to indicate pages being migrated out of this buffer pool will be stored in the extended storage.

To use extended storage, this check box must be selected and the num_estore_segs configuration parameter must be greater than zero.

Select all nodes

This radio button is not available when altering a buffer pool.

Select nodes by nodegroups

This radio button is not available when altering a buffer pool.

If this 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.)

Change size of buffer pool by node

To change the size of the buffer pool for one or more nodes, select the nodes and then type the new size in the Size in pages field.

To change the size of all nodes to be the same, click on the Select all push button.

To reset sizes for the selected nodes back to the value in the buffpage database configuration parameter, click on the Default push button.

>>, >, <, <<

Use these push buttons to change the list of nodegroups displayed in the Available nodegroups and Selected nodegroups list boxes:

>>

All nodegroups displayed in the Available nodegroups box are moved to the Selected nodegroups box.

>

Selected nodegroups in the Available nodegroups box are moved to the Selected nodegroups box.

<

Selected nodegroups in the Selected nodegroups box are moved to the Available nodegroups box.

<<

All nodegroups in the Selected nodegroups box are moved to the Available nodegroups box.

Note:

This push button is not available when altering a buffer pool, because you cannot remove the nodegroups that were used to create it.