Create Buffer Pool -- Fields and controls

Buffer pool name

Page size

Size in pages

Use extended storage

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.

Size in pages

Type the size of the buffer pool in pages.

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.