Creating a buffer pool

Use the Create Buffer Pool window to create a new buffer pool.

Attention:The new buffer pool will become active when you restart the database. Until then, any new tables or table spaces will use the default buffer pool. Any changes to a table space that specifies this buffer pool will continue to use its existing buffer pool.

Fields and controls

Authorities and privileges



To create a buffer pool:

  1. Open the Create Buffer Pool window.

  2. In the Buffer pool name field, type a new name for the buffer pool.

  3. 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.

  4. In the Size in pages field, type the size of the buffer pool in pages.

  5. Optional: To specify whether or not pages being migrated out of this buffer pool will be stored in the extended storage, select the Use extended storage check box.

  6. Click on OK to create the buffer pool.


Related information