Neoview Workload Management Services Guide (R2.4)

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 ROLE.DBA or the super ID (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 | {EXEC "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 9 and HPS_TRANSPORTER1. The rule
name is not case-sensitive and is always converted to uppercase. 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.
ADD RULE COMP Command 83