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.
|
Default Size |
Specifies 1000 pages as 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. |
Self Tuning |
Enables the database manager to adjust the size
of the buffer pool in response to workload requirements. The implicit
or explicit number of pages specified is used as the initial size
of the buffer pool. |
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. |
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. |