Neoview Workload Management Services Guide (R2.4)

For a compilation rule that specifies a warning level, if you do not specify an action and the
compilation rule evaluates to true, WMS saves warning information and then determines if there
are enough resources to execute the query.
Adding a Comment for the Compilation Rule
You can optionally provide a comment to describe the rule that you are creating. You must
delimit the comment in double quotes. For example, this ADD RULE COMP command has a
comment that identifies who created the compilation rule and when it was created:
ADD RULE COMP COMPRULE6 (UPDATE_STATS_WARNING,
WARN-MEDIUM) COMMENT "Created by DBA on 5/14/2009";
Displaying the Definition of a Compilation Rule
Use the STATUS RULE command to display the definition of a compilation rule. For example,
this STATUS RULE command displays the definition of the compilation rule, COMPRULE1:
NS%status rule comprule1;
TYPE NAME OPER EXPR_PRTY EXPR WARN_LEVEL ACT COMMENT
---- ---------- ---- ----------- -------------------------- ---------- ----------------------- ----------------
COMP COMPRULE1 AND 1 EST_USED_ROWS > 50000 HIGH REJECT
--- WMS operation complete.
NS%
For the syntax, see the “STATUS RULE Command” (page 138). Also see “How to Execute WMS
Commands in NCI” (page 25).
Displaying the Definitions of All Compilation Rules
Use the STATUS RULE COMP command to display the definitions of all compilation rules in
WMS:
NS%status rule comp;
TYPE NAME OPER EXPR_PRTY EXPR WARN_LEVEL ACT COMMENT
---- ---------- ---- ----------- --------------------------- ---------- ---------------------- -------------
COMP COMPRULE1 AND 1 EST_USED_ROWS > 50000 HIGH REJECT
COMP COMPRULE2 AND 1 EST_USED_ROWS > 25000 MEDIUM HOLD
COMP COMPRULE3 AND 1 EST_USED_ROWS > 1000 LOW
--- WMS operation complete.
NS%
For the syntax, see the “STATUS RULE COMP Command” (page 139). Also see “How to Execute
WMS Commands in NCI” (page 25).
Altering a Compilation Rule
IMPORTANT: To remove an action from a compilation rule, you must delete and then add the
compilation rule instead of using the ALTER RULE COMP command. For more information,
see “Deleting a Connection Rule” (page 46) and “Adding a Compilation Rule” (page 53).
Use the ALTER RULE COMP command to change the attributes of a compilation rule. This
ALTER RULE COMP command changes the estimated used rows from greater than fifty thousand
to greater than or equal to fifty thousand in the compilation rule, COMPRULE1:
NS%ALTER RULE COMP COMPRULE1 (EST_USED_ROWS >= 50000, WARN-HIGH, REJECT);
--- WMS operation complete.
56 Configuring Rules