AvePrefetchReadTime (DB2UDB_BUFFERPOOL)
Indicates the average asynchronous read time required by the Database Manager prefetchers each time data is read from disk into the bufferpool. This parameter indicates that amount of input/output work being performed by the Database Manager prefetchers and helps 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.
To reset this parameter's value, set monitor switch to OFF, and then set monitor switch to ON to begin monitoring this parameter again. This will reset the counters for all the parameters that are being controlled by the monitor switch.
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 | Milliseconds |
Annotated? | No |
Value set by | CollBufferpool |