The Buffer Pool Characteristics section
The buffer pool characteristics values are retrieved from IFCID 202.
This section is the same as in summary reports. See The Buffer Pool Characteristics section for a description of the elements.
========= Buffer Pool Characteristics =========
BPID BP0 BP1 BP2 BP3 BP4 BP5
-------------------------- -------- -------- -------- -------- -------- --------
General
Virtual pool size 2000 1000 1000 1000 1000 1000
Pages fixed in real stor No No No No No No
Page steal method LRU LRU LRU LRU LRU LRU
Autosize attribute No No No No No Yes
Thresholds
Virtual sequential 80 80 80 80 80 80
Deferred write 50 50 50 50 50 50
Vert deferred write(buff) 0 0 0 0 0 0
Vert deferred write (%) 10 10 10 10 10 10
Parallel sequential 50 50 50 50 50 50
Assisting parallel seq 0 0 0 0 0 0
========================== ======== ======== ======== ======== ======== ========
BPID BP6 BP7 BP8 BP9 BP32K BP32K1
-------------------------- -------- -------- -------- -------- -------- --------
General
Virtual pool size 1000 1000 1000 1000 24 24
Pages fixed in real stor No No No No No No
Page steal method LRU LRU LRU LRU LRU LRU
Autosize attribute No No No No No Yes
Thresholds
Virtual sequential 80 80 80 80 80 80
Deferred write 50 50 50 50 50 50
Vert deferred write(buff) 0 0 0 0 0 0
Vert deferred write (%) 10 10 10 10 10 10
Parallel sequential 50 50 50 50 50 50
Assisting parallel seq 0 0 0 0 0 0
========================== ======== ======== ======== ======== ======== ========
BPID BP32K2 BP8K0 BP8K1 BP8K2 BP16K0 BP16K1
-------------------------- -------- -------- -------- -------- -------- --------
General
Virtual pool size 24 100 100 100 50 50
Pages fixed in real stor No No No No No No
Page steal method LRU LRU LRU LRU LRU LRU
Autosize attribute No No No No No Yes
Thresholds
Virtual sequential 80 80 80 80 80 80
Deferred write 50 50 50 50 50 50
Vert deferred write(buff) 0 0 0 0 0 0
Vert deferred write (%) 10 10 10 10 10 10
Parallel sequential 50 50 50 50 50 50
Assisting parallel seq 0 0 0 0 0 0
========================== ======== ======== ======== ======== ======== ========
1 DB2 BUFFER POOL ANALYZER (V5R2M0) - BUFFER POOL ACTIVITY REPORT PAGE: 1-2
ORDER: BPID-QPAGESET
TOP: 11 LEVEL: DETAIL
GROUP: N/P LOCATION: PMO2D721 DB2 VERSION: V11
MEMBER: N/P REQUESTED FROM: NOT SPECIFIED TO: NOT SPECIFIED
SUBSYSTEM: D721 INTERVAL FROM: 12/06/13 16:08:30 TO: 12/06/13 16:09:22
========= Buffer Pool Characteristics =========
BPID BP16K2
-------------------------- --------
General
Virtual pool size 50
Pages fixed in real stor No
Page steal method LRU
Autosize attribute No
Thresholds
Virtual sequential 80
Deferred write 50
Vert deferred write(buff) 0
Vert deferred write (%) 10
Parallel sequential 50
Assisting parallel seq 0
========================== ========