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.
|
Before you begin...
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
and 8KB.
- 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.
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]