Create Buffer Pool -- Fields and controls

Use the Create Buffer Pool window to create a new 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

Type a unique name for the buffer pool that you're creating. This name:

• Can contain from 1 to 18 characters.
• Can be an ordinary or delimited identifier.

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.

To change the page size :

• Click on the arrow key to see a list of page sizes and select one.

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

Select this radio button to create the buffer pool on all nodes in the database.

Select nodes by nodegroups

Select this radio button to identify nodegroups to which the buffer pool definition applies. The buffer pool will be created on all the nodes in each of the selected nodegroups.

Click on the arrow push buttons to move the selected nodegroups between the Available nodegroups and Selected nodegroups boxes.

If you select this radio button, you must select one or more groups from the list of Available nodegroups.

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.