Neoview Workload Management Services Guide (R2.5)

ALTER RULE COMP Command
The ALTER RULE COMP command alters the attributes of 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
ALTER 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;" } | NO-ACTION }
rule-comment is:
{ COMMENT "comment-string" }
rule-name
is the name of an existing compilation rule.
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.
rule-specifier-list
specifies one or more comma-separated comp-expression. WMS tests each
comp-expression in the rule-specifier-list in the order in which you specify them.
A rule-specifier-list can contain a maximum of 15 comp-expression.
ALTER RULE COMP Command 189