Buffer pool properties (DB2 for Linux, UNIX, and Windows)

Properties for DB2® for Linux®, UNIX®, and Windows® buffer pool objects

For more information about specific syntax, see the reference information that is included with each database product. Syntax definitions for some database vendors or versions might differ from the following descriptions.

General page
Property Description
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.
Partitioning page
Property Description
All Partitions Specifies that the buffer pool is created on all database partitions in the database.
Partition Group Specifies the database partition group or groups to which the buffer pool definition applies. If this parameter is specified, the buffer pool is only to be created on database partitions in these database partition groups. Each database partition group must currently exist in the database.
Size Exceptions Specifies the size of the buffer pool on specific partitions.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.

Feedback