IntAutoRebindTotStmts (DB2DB_SQL)
Indicates the ratio of the total number of automatic rebinds or recompiles that have been attempted to the total SQL statements attempted against the selected database. This parameter is helpful in analyzing various database activity and throughput.
Recommendation
Internal automatic rebinds can have a significant impact on system performance and should be minimized as much as possible.
Default parameter attributes
Attribute | Default value |
|---|---|
Application class | DB2EEEDB_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*