DSNB402I BUFFER POOL SIZE = pool-size BUFFERS AUTOSIZE = autosize VPSIZE MINIMUM = minimum size VPSIZE MAXIMUM = maximum-size ALLOCATED = allocated-buffers TO BE DELETED = delete-buffers IN-USE/UPDATED = current-buffers OVERFLOW ALLOC = over-buffers

The basic buffer pool information is followed by a description of the allocation status of the buffer pool.

The values of VPSIZE MINIMUM and VPSIZE MAXIMUM are used only when AUTOSIZE =YES.

DSNB402I - BUFFER POOL SIZE = pool-size BUFFERS  AUTOSIZE = autosize
           VPSIZE MINIMUM = minimum size VPSIZE MAXIMUM = maximum-size
             ALLOCATED      = allocated-buffers   TO BE DELETED   = delete-buffers
             IN-USE/UPDATED = current-buffers
             OVERFLOW ALLOC = over-buffers

BUFFER POOL SIZE = pool-size BUFFERS

The user-specified buffer pool size.

AUTOSIZE = autosize

The buffer pool AUTOSIZE attribute that is applicable to the current allocation of the buffer pool.

YES

The buffer pool uses Workload Manager (WLM) services, if available, to automatically adjust the size of the buffer pool. The size is adjusted based on dynamic monitoring of the workload goals and the storage that is available on the system.

NO

The buffer pool does not use WLM services for automatic sizing adjustment of buffer pools.

VPSIZE MINIMUM = minimum size

The minimum size of the buffer pool. This value is meaningful only when the value of autosize is YES. If the value was never specified, a value of 0 is shown, and Db2 uses a default value of 75% of the specified value of VPSIZE.

VPSIZE MAXIMUM = maximum-size

The maximum size of the buffer pool. This value is meaningful only when the value of autosize is YES. If the value was never specified, a value of 0 is shown, and Db2 uses the defaults value, which is 25% greater than the specified VPSIZE value.

ALLOCATED = allocated-buffers

The number of allocated buffers in an active buffer pool.

TO BE DELETED = delete-buffers

The number of buffers to be deleted in an active buffer pool because of pool contraction.

IN-USE/UPDATED = current-buffers

The number of currently active buffers in the buffer pool. These buffers cannot be stolen.

OVERFLOW ALLOC = over-buffers

The number of allocated buffers in the overflow area for a buffer pool that uses PGSTEAL(NONE). The buffers that are allocated to the overflow area are counted within of the VPSIZE value, and they are counted as part of the ALLOCATED value.