Neoview Workload Management Services Guide (R2.4)

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
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 classification. 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 this action:
CANCEL
stops the NDCS process in which the query is running.
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
include dashes, periods, underscores, and spaces. You must delimit the comment in double
quotes.
Examples
• This command changes the value of the number of rows used by the query.
ALTER RULE EXEC EXECRULE50 (USED_ROWS = 20);
100 WMS Commands