Altering buffer pools

Db2 stores buffer pool attributes in the Db2 bootstrap data set (BSDS). You can change buffer pool attributes.

About this task

Buffer pool attributes, including buffer pool sizes, sequential steal thresholds, deferred write thresholds, and parallel sequential thresholds, are initially defined during the Db2 installation process.

Introductory concepts

Buffer pools
The role of buffer pools in caching data

Procedure

To alter buffer pool attributes:

Issue the ALTER BUFFERPOOL command.