BPIndxPgCleanEff (DB2UDB_BUFFERPOOL)
Indicates the ratio of asynchronous index writes to synchronous index writes. This parameter can be used to determine the correct setting of the num_iocleaners configuration parameter.
The BUFFERPOOL DB2 Monitor Switch must be set ON to make this parameter active and collect data.
Parameter value calculation
Buffer Pool Async Index Writes / (Buffer Pool Index Writes - Buffer Pool Async Index Writes)
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 |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*