Neoview Workload Management Services Guide (R2.4)

ALTER RULE EXEC Command
The ALTER RULE EXEC command alters the attributes of an execution rule.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is ROLE.DBA or the super ID (super.services or super.super).
Syntax
ALTER RULE EXEC rule-specifier
rule-specifier is:
rule-name ( [ rule-specifier-operator, ] rule-specifier-list
[, warn-level] [, rule-action ])}
[ rule-comment ]
rule-specifier-operator is:
{ AND | OR }
rule-specifier-list is:
exec-expression [, exec-expression ] ...
exec-expression is:
{ USED_ROWS rule-operator EST_USED_ROWS | numeric-value }
| { ACCESSED_ROWS rule-operator EST_ACCESSED_ROWS | numeric-value }
| { TOTAL_MEM_ALLOC rule-operator EST_TOTAL_MEMORY | numeric-value }
| { ELAPSED_TIME rule-operator numeric-value }
rule-operator is:
{ = | >= | > | < | <= | < > | percentage%}
warn-level is:
{ WARN-HIGH
| WARN-MEDIUM
| WARN-LOW
| NO-WARN }
rule-action is:
CANCEL
rule-comment is:
{ COMMENT "comment-string" }
rule-name
is the name of an existing execution rule.
rule-specifier-operator
If you specify AND, all exec-expression in the rule-specifier-list must be true
to trigger rule-action.
If you specify OR, a single exec-expression in the rule-specifier-list must be true
to trigger rule-action.
If you do not specify an operator, the default is AND.
rule-specifier-list
specifies one or more comma-separated exec-expression. WMS tests each
exec-expression in the rule-specifier-list in the order in which you specify them.
A rule-specifier-list can contain a maximum of 15 exec-expression.
ALTER RULE EXEC Command 99