Configuration: Buffer Pools (DB2 UDB for UNIX and Windows) 

You can access information on available buffer pools by calling the DBA Cockpit and choosing Configuration ® Buffer Pools in the navigation frame of the DBA Cockpit. The Configuration: Buffer Pools screen appears.

The following information is displayed:

Column	Description
Buffer Pool Name	Name of the buffer pool
Partition	Number of the partition
Size (Pages)	Size of the buffer pool in KB. A value of –1 indicates that the default buffer pool size parameter from the database configuration is used (parameter BUFFPAGE). If this value is displayed and you want to see the real size of the buffer pool, you should use the buffer pool snapshot.
Page Size (Byte)	Size of one buffer pool page in bytes
Extended Storage	Indicates the use of extended storage: ·        N: Extended storage is not used. ·        Y: Extended storage is used.

 

The list of buffer pools contains all buffer pools that have been defined for the selected partition. If you choose ALL in the Partitions field, all available buffer pools will be displayed.

In addition, you can maintain buffer pools, that is change, add or delete them. For more information, see Maintaining Buffer Pools.