Neoview Workload Management Services Guide (R2.4)

rule-action
specifies an action to take if rule-specifier-list evaluates to true. If you specify a
NO-WARN warn-level, you must specify a rule-action. For a compilation rule, you
can specify one of these actions:
REJECT | HOLD | { EXEC "sql-string;" }
REJECT
causes the query to be rejected.
HOLD
causes the query to be put in the holding state.
EXEC "sql-string;"
causes the NDCS server to execute an SQL command (or a series of SQL commands)
before executing the query.
“sql-string;”
is an SQL command string. You must enclose the SQL string in double quotes. The
combined length for the command string must not exceed 1024 bytes. Separate each
command with a semicolon (;). The last command must always end with a semicolon.
The string can contain multibyte characters. For information on using multibyte
character sets, see the Neoview Character Sets Administrator's Guide.
rule-comment
is optional text that you can specify to describe the rule you are creating. comment-string
cannot exceed 256 characters. You must enclose the comment in double quotes.
Considerations
• If you specify NO-WARN, you must specify a rule-action.
• Use the ALTER SERVICE COMP command to associate compilation rules with a service.
• You cannot add a rule that begins with the reserved “HPS_” prefix or that has the same
name as one of the predefined rules, HPS_MANAGEABILITY1 through 9 and
HPS_TRANSPORTER1.
Examples
• These commands define several compilation rules:
ADD RULE COMP COMPRULE1 (EST_USED_ROWS > 50000, WARN-HIGH, REJECT);
ADD RULE COMP COMPRULE2 (EST_USED_ROWS > 25000, WARN-MEDIUM, HOLD);
ADD RULE COMP COMPRULE3 (EST_USED_ROWS >= 1000, WARN-LOW);
ADD RULE COMP Command 85