BPDataWriteReadRatio (DB2UDB_BUFFERPOOL)
Indicates the number of data reads requiring page-ins to the buffer pool that cause writes (page-outs) to disk. This parameter can be used to determine the correct setting of the buffpage configuration parameter.
Buffer pools are not allocated when no applications are connected to a database, so the first application that connects may experience a high index write/read ratio during the initial startup due to the buffer pool being allocated.
The BUFFERPOOL DB2 Monitor Switch must be set ON to make this parameter active and collect data.
Recommendation
If this value is too high, increasing the number of buffer pool pages available for a database may improve performance.
Parameter value calculation
Buffer Pool Data Writes / Buffer Pool Data Physical Reads
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 |