COLLECT_STATIC_SQL
Use the COLLECT_STATIC_SQL parameter in CQMPARMS to control the metrics collection behavior of your Query Monitor Subsystem with respect to static SQL statements.
- Description
- Specifies whether or not to collect statistics for static SQL statements.
- Syntax
- COLLECT_STATIC_SQL(Y|N)
- Valid values
-
- Y
- (Default) Collect statistics for static SQL statements.
- N
- Do not collect statistics for static SQL statements.
- Example
- COLLECT_STATIC_SQL(N)