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)