Average of number sectors written per direct write (AveNumSectorsWritten)
This parameter indicates the average number of Sectors written by a direct write request at the database or bufferpool level. This parameter can be used to determine how much DB2-related input/output activity is occurring.
Direct writes are performed by DB2 when: reading LONG VARCHAR columns, reading large object (LOB) columns, performing a restore operation, or performing a load operation.
Default parameter attributes
Attribute | Default value |
|---|---|
Application class | DB2_BUFFERPOOL |
Command type | Not applicable |
Platform | All |
Icon style | Graph |
Unit | Number (#) |
Border range | Undefined |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling (poll time) | Inherited |
Active at installation | No |
Parameter type | Consumer |
Value set by | dataCollector |
TrueSight/ BMC Helix Operations Management properties
Attribute | Default value |
|---|---|
| Monitor type | DB2 Buffer Pool |
Key Performance Indicator | No |
| Monitor for abnormalities | Yes |
| Graph by default | Yes |
| Availability | No |
| Response time | No |
| Normal distribution | Yes |
| Statistical | No |
Comments
Log in or register to comment.