Neoview Workload Management Services Guide (R2.5)

ADD RULE EXEC Command
The ADD RULE EXEC command defines an execution rule.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is a user associated with ROLE.DBA, SUPER.SERVICES, or SUPER.SUPER.
Syntax
ADD 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 }
| { CPU_TIME rule-operator EST_CPU_TIME | 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 a user-defined rule. rule-name can be a maximum of 24 characters and must
be a unique name in WMS. You cannot add a rule that has the same name as one of the
predefined rules, HPS_MANAGEABILITY1 through 11 and HPS_TRANSPORTER1. The
rule name is not case-sensitive and is always converted to uppercase. The rule name cannot
contain spaces. WMS supports multibyte characters in the rule name. For guidelines on using
multibyte character sets, see the Neoview Character Sets Administrator's Guide.
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.
182 WMS Commands