BPIndxWriteReadRatio (DB2UDB_BUFFERPOOL)
Indicates the ratio of the number of times a buffer pool index page is physically written to disk to the number of read requests required to read index pages into the buffer pool. This parameter can be used to determine the correct setting of the buffpage configuration parameter.
The BUFFERPOOL DB2 Monitor Switch must be set ON to make this parameter active and collect data.
Parameter value calculation
Default parameter attributes
Attribute | Default value |
|---|---|
Application class | DB2UDB_BUFFERPOOL |
Command type | not applicable |
Platform | All |
Active at installation | yes |
Parameter type | Consumer |
Scheduling (poll time) | not applicable |
Icon style | Graph |
Alarm 1 range | not applicable |
Alarm 2 range | not applicable |
Border range | not applicable |
Unit | Number |
Annotated? | No |
Value set by | CollBufferpool |