Fields in the Database-Buffer-Pool report
The following figure is an example of a Database Buffer Pool report.
D A T A B A S E B U F F E R P O O L
FIX PREFIX/BUFFERS Y/Y
SUBPOOL ID O04K
SUBPOOL BUFFER SIZE 4096
TOTAL BUFFERS IN SUBPOOL 1000
17:08:15 17:10:16
NUMBER OF LOCATE-TYPE CALLS 1117674 1676213 558539
NUMBER OF REQUESTS TO CREATE NEW BLOCKS 0 0 0
NUMBER OF BUFFER ALTER CALLS 215874 322936 107062
NUMBER OF PURGE CALLS 25077 37454 12377
NUMBER OF LOCATE-TYPE CALLS, DATA ALREADY IN OSAM POOL 870306 1301187 430881
NUMBER OF BUFFERS SEARCHED BY ALL LOCATE-TYPE CALLS 1258247 1886843 628596
NUMBER OF READ I/O REQUESTS 238165 360260 122095
NUMBER OF SINGLE BLOCK WRITES BY BUFFER STEAL ROUTINE 0 0 0
NUMBER OF BLOCKS WRITTEN BY PURGE 95057 142413 47356
NUMBER OF LOCATE CALLS WAITED DUE TO BUSY ID 780 1297 517
NUMBER OF LOCATE CALLS WAITED DUE TO BUFFER BUSY WRT 0 0 0
NUMBER OF LOCATE CALLS WAITED DUE TO BUFFER BUSY READ 0 0 0
NUMBER OF BUFFER STEAL/PURGE WAITED FOR OWNERSHIP RLSE 178 261 83
NUMBER OF BUFFER STEAL REQUESTS WAITED FOR BUFFERS 0 0 0
TOTAL NUMBER OF I/O ERRORS FOR THIS SUBPOOL 0 0 0
NUMBER OF BUFFERS LOCKED DUE TO WRITE ERRORS 0 0 0
The meaning of the various fields in the report is as follows:
- FIX PREFIX/BUFFERS
- This field indicates the fix options for the buffer prefix/data buffers for this subpool.
- SUBPOOL ID
- This field is a 4 character pool ID provided at subpool definition time.
- SUBPOOL BUFFER SIZE
- This field indicates the size, in bytes, of the buffers in this subpool.
- TOTAL BUFFERS IN SUBPOOL
- This field indicates the total number of buffers in this subpool.
On the following line are time entries that indicate the start trace and end trace times. The start trace and end trace fields tell you the time when the DB Monitor program was last started and stopped.
- NUMBER OF LOCATE-TYPE CALLS
- This field indicates the number of locate-type calls for this subpool.
- NUMBER OF REQUESTS TO CREATE NEW BLOCKS
- This field indicates the number of times a block had a segment inserted for the first time. When this happens, the block is marked as modified and must eventually be written back to the database.
- NUMBER OF BUFFER ALTER CALLS
- This field indicates the number of buffer alter calls for this subpool. This count includes NEW BLOCK and BYTALT calls.
- NUMBER OF PURGE CALLS
- This field indicates the number of purge requests for this subpool.
- NUMBER OF LOCATE-TYPE CALLS, DATA ALREADY IN SUBPOOL
- This field indicates the number of locate-type calls for this subpool where the data was already in an OSAM pool.
- NUMBER OF BUFFERS SEARCHED BY ALL LOCATE-TYPE CALLS
- This field indicates the number of buffers searched by all locate-type calls for this subpool.
- NUMBER OF READ I/O REQUESTS
- This field indicates the number of read I/O requests for this subpool.
- NUMBER OF SINGLE BLOCK WRITES BY BUFFER STEAL ROUTINE
- This field indicates the number of single block writes initiated by buffer steal routine for this subpool.
- NUMBER OF BLOCKS WRITTEN BY PURGE
- This field indicates the number of blocks for this subpool written by purge.
- TOTAL NUMBER OF I/O ERRORS FOR THIS SUBPOOL
- This field indicates the total number of I/O errors for this subpool.
- NUMBER OF BUFFERS LOCKED DUE TO WRITE ERRORS
- This field indicates how many buffers are currently
frozen
in storage because a permanent I/O error occurred when writing them to the database. When a write operation results in a permanent I/O error, the affected buffers are frozen in storage until the data set is closed or, in an online system, until the system is shut down. Once the data set is closed, or the online system shut down, the buffers are written to the log, and this number returns to 0. - NUMBER OF LOCATE CALLS WAITED DUE TO BUSY ID
- This field indicates the number of locate calls for this subpool which waited due to busy ID.
- NUMBER OF LOCATE CALLS WAITED DUE TO BUFFER BUSY WRT
- This field indicates the number of locate calls for this subpool which waited due to buffer busy writing.
- NUMBER OF LOCATE CALLS WAITED DUE TO BUFFER BUSY READ
- This field indicates the number of locate calls for this subpool which waited due to buffer busy reading.
- NUMBER OF BUFFER STEAL/PURGE WAITED DUE TO BUFFER BUSY READ
- This field indicates the number of locate calls for this subpool which waited for ownership to be released.
- NUMBER OF BUFFER STEAL REQUESTS WAITED FOR BUFFERS
- This field indicates the number of buffer steal requests for this subpool which waited because no buffers were available to be stolen.