Db2 Buffer Pool Attributes

Use these attributes to get information about Db2 buffer pools.

Assisting Parallel Seq The assisting parallel sequential threshold. Valid values are 1 to 100 (Field name: QDBPXSQT).

Buffer Pool ID Buffer Pool Name (Field name: QDPNM).

Data Sharing Group The data sharing group name (Field name: GROUP).

Db2 Subsystem The Db2 subsystem ID (Field name: DB2ID).

Db2 Version The Db2 version (Field name: DB2VER).

Vert Deferred Write Thresh The vert deferred write threshold of the buffer pool (Field name: QDBPVDQT). The value is between X'00' and X'5A'.

Deferred Write Thresh The deferred write threshold of the buffer pool (Field name: QDBPVDQT). The value is between X'00' and X'5A'.

DSG Member Name The Data Sharing Group (DSG) member name (Field name: MEMBER).

Frame Size The framesize attribute: '4K', '1M', or '2G' (Field name: QDBPFRAM).

Interval Start The start time of this interval (Field name: TIMESTAMP).

MVS System ID The MVS identifier (Field name: MVSID).

Originating System The managed system name of the agent (Field name: ORIGINNODE). It is an alphanumeric text string, with a maximum of 32 characters; for example, DB91:SYS1:DB2.

PGSTEAL Attribute PGSTEAL attribute (Field name: QDBPPGST).
  • 'l' means the buffers are managed using the least recently used (lru) algorithm.
  • 'f' means the buffers are managed using the first in first out (FIFO) algorithm.
  • 'n' means that no page stealing occurs. Data that is brought in stays resident.

Simulated BP size Simulated buffer pool size (Field name: QDBPSPSZ) A sequential prefetch request does not result in read I/O if the requested pages are found in the buffer pool.

SimPool Seq threshold The simulated buffer pool sequential threshold (Field name: QDBPSPST).

Virtual Buffer Pool Size The size of the virtual buffer pool (Field name: QDBPVPSZ).

VP Sequential Thresh The virtual pool sequential steal threshold of the buffer pool (Field name: QDBPVPSH). This value is between X'00' and X'64'.

VP Parallel Sequential Thresh The parallel sequential threshold. Valid values are 1 to 100 (Field name: QDBPPSQT). This value is between X'00' and X'64'.

VP Write Threshold The pool vertical write threshold, in number of buffers. Valid values are 0 to 9999 (Field name: QDBPVDQB). This field is used to determine the threshold only if VBDPVDQT is zero and QDBPVDQB is non-zero.

VPSIZEMIN Attribute VPSIZEMIN attribute (Field name: QBDPVPMI).

VPSIZEMAX Attribute VPSIZEMAX attribute (Field name: QBDPVPMA).