Name |
Specifies a name for the object. |
Label |
Specifies a label that is displayed in visual
diagrams. |
Create Type |
Specifies whether the buffer pool will be created
immediately.- IMMEDIATE
- The buffer pool is created immediately. If there is not enough
reserved space in the database shared memory to allocate the new buffer
pool, the statement is executed as DEFERRED.
- DEFERRED
- The buffer pool is created when the database is deactivated (all
applications must be disconnected from the database). Reserved memory
space is not needed; DB2 will
allocate the required memory from the system.
|
Size |
Specifies the size of the buffer pool. For a
partitioned database, this will be the default size for all database
partitions on which the buffer pool exists. The default is 1000 pages. |
Page Size |
Defines the size of pages used for the buffer
pool. Valid values are displayed in the list. |
Block Size |
Specifies the number of pages in a block. The
block size must be a value between 2 and 256. The default value is
32. |
Block Pages |
Specifies the number of pages that should exist
in the block-based area. The number of pages must not be greater than
98 percent of the number of pages for the buffer pool. Specifying
the value 0 disables block I/O. The actual value of NUMBLOCKPAGES
used will be a multiple of BLOCKSIZE. |
Extended Storage |
This option is no longer supported in DB2 for Linux, UNIX,
and Windows version 9.1
or higher. |