DDLTotStmts (DB2DB_SQL)
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. Be aware that 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_NODE_SQL |
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 | Percentage |
Annotated? | No |
Value set by | CollDatabase |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*