DB2 Version 9.7 for Linux, UNIX, and Windows

bp_new_buffsz - New Buffer Pool Size monitor element

The size the buffer pool will be changed to once the database is restarted. When the ALTER BUFFERPOOL statement is executed as DEFERRED, the buffer pool size is not changed until the database is stopped and restarted.

Table 1. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Buffer Pool bufferpool_nodeinfo Buffer Pool
Parent topic: Database system monitor elements