Use the Create Buffer Pool window to create a new buffer pool.
| Note: | The new buffer pool will become active when you restart the database.
Until then, any new tables or table spaces will use the existing buffer
pool. Any changes to a table space that specifies this buffer pool will
continue to use its existing buffer pool until after you restart the
database.
|
Fields and controls
Authorities and privileges
To create a buffer pool for a partitioned database:
- Open the Create Buffer Pool window.
- In the Buffer pool name field,
type a new name for the buffer pool.
- In the Page size field, specify
the size of the pages to be used for the buffer pool. The valid values
are 4KB, 8KB, 16KB, and 32KB.
- Optional: To specify that pages being migrated out of this buffer
pool will be stored in the extended storage, select the Use extended storage check box.
- Specify on which nodes you want the buffer pool
created:
- To create the buffer pool on all nodes in the database, select the
Select all nodes button.
- To identify the nodegroups to which the
buffer pool definition applies, use the Select nodes by nodegroups
radio button. Click on the arrow push
buttons to move the selected nodegroups between the Available
nodegroups and Selected nodegroups boxes.
- Optional: To modify the default size of the buffer pool on selected
nodes, select the nodes from the Change size of buffer pool by node box,
and then type the new size in the Size in pages field.
- Click on OK to create the buffer pool.