Neoview Workload Management Services Guide (R2.5)

exec-expression
specifies one of these execution rule expressions:
An expression comparing the number of rows returned with
either the estimated number of rows used by the query or a
numeric value that you specify.
USED_ROWS rule-operator
EST_USED_ROWS | numeric-value
An expression comparing the number of rows accessed with
either the estimated number of rows accessed or a numeric
value that you specify.
ACCESSED_ROWS rule-operator
EST_ACCESSED_ROWS | numeric-value
An expression comparing the TOTAL_MEM_ALLOC, which
is the sum of SQL_SPACE_USED and SQL_HEAP_USED,
with the estimated total memory per CPU used by the query
or a numeric value that you specify. The value of the second
operand, numeric-value, is in kilobytes.
TOTAL_MEM_ALLOC rule-operator
EST_TOTAL_MEMORY | numeric-value
An expression comparing the elapsed time of the query
execution with a numeric value that you specify. The value
of the second operand, numeric-value, is in minutes.
ELAPSED_TIME rule-operator
numeric-value
An expression comparing the amount of processor (CPU)
time, in seconds, used by Neoview SQL for the query with
either the estimated CPU time or a numeric value that you
specify.
IMPORTANT: If you specify CPU_TIME, be aware that the
query cost model, which influences the CPU time, might
change in the future.
CPU_TIME rule-operator EST_CPU_TIME |
numeric-value
rule-operator
specifies the operator to use when comparing the first operand of the exec-expression
to the second operand. The rule-operator can be:
= | >= | > | < | <= | <> | percentage%
percentage%
specifies that the first operand of exec-expression is greater than some percentage (for
example, 200 percent) of the second operand of exec-expression. A valid range is 100 to
1000 percent.
numeric-value
specifies a number in the range of 0 to 9223372036854775807.
warn-level
specifies the warning level. warn-level can be one of these values:
• WARN-HIGH
• WARN-MEDIUM
• WARN-LOW
• NO-WARN
If you do not specify a warning level, the default is WARN-LOW.
rule-action
specifies an action to take if rule-specifier-list evaluates to true. For an execution
rule, you can specify one of these actions:
CANCEL
cancels the executing query without stopping the NDCS server in which the query is
running.
NO-ACTION
removes an existing action from the rule.
rule-comment
is optional text that you can specify to describe the rule you are creating. comment-string
cannot exceed 256 characters. In addition to alphanumeric characters, the comment can
ALTER RULE EXEC Command 197