DDL to total statements attempted (DDLTotStmts)
This parameter indicates the ratio of SQL DDL statements to total SQL statements that have been attempted against the selected database. This parameter is helpful in analyzing database activity and throughput.
DDL statements produce a large amount of overhead due to their impact on the system catalog tables.
Default parameter attributes
Attribute | Default value |
---|---|
Application class | DB2DB_SQL |
Command type | Not applicable |
Platform | All |
Icon style | Graph |
Unit | Percent |
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 Database Sql |
Key Performance Indicator | No |
Monitor for abnormalities | Yes |
Graph by default | Yes |
Availability | No |
Response time | No |
Normal distribution | Yes |
Statistical | No |
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Log in or register to comment.