Buffer pool name
Page size
Size in pages
Use extended storage
OK
Show SQL
Cancel
Buffer pool name
Page size
Size in pages
Use extended storage
OK
Show SQL
Cancel
Buffer pool name
This field displays the name currently specified for the buffer pool that you're altering. You cannot alter the buffer pool name.
To alter another buffer pool instead of the one you selected, click on Cancel to return to the Control Center and select another buffer pool.
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.
You cannot alter the page size.
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.