Neoview Workload Management Services Guide (R2.5)

ADD RULE COMP Command
The ADD RULE COMP command defines a compilation 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 COMP 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:
comp-expression [, comp-expression ] ...
comp-expression is:
{ EST_TOTAL_MEMORY rule-operator numeric-value }
| { EST_TOTAL_TIME rule-operator numeric-value }
| { EST_CARDINALITY rule-operator numeric-value }
| { EST_ACCESSED_ROWS rule-operator numeric-value }
| { EST_USED_ROWS rule-operator numeric-value }
| { NUM_JOINS rule-operator numeric-value }
| { SCAN_SIZE rule-operator numeric-value }
| { UPDATE_STATS_WARNING }
| { CROSS_PRODUCT }
rule-operator is:
{ = | >= | > | < | <= | < > }
warn-level is:
{ WARN-HIGH
| WARN-MEDIUM
| WARN-LOW
| NO-WARN }
rule-action is:
{ REJECT | HOLD | {SQL_CMD "sql-string;"} }
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 comp-expression in the rule-specifier-list must be true
to trigger rule-action.
If you specify OR, a single comp-expression in the rule-specifier-list must be true
to trigger rule-action.
If you do not specify an operator, the default is AND.
174 WMS Commands