Neoview Workload Management Services Guide (R2.5)
6. If you want WMS to take an action when the rule evaluates to true:
a. From the Action list, select one of these actions:
DescriptionAction
Causes the query to be rejected
REJECT
Puts the query in the holding state
HOLD
Causes the NDCS server to execute one or more SQL commands before
executing the query
SQL_CMD
You must specify one of those actions if you specify NO-WARN for the warning level.
b. If you selected SQL_CMD, enter one or more SQL commands in the SQL String box.
Those SQL commands will execute when the rule evaluates to true.
7. Specify one to fifteen compilation rule expressions to define the conditions that must be met
for the compilation rule to evaluate to true and trigger a warning level or action:
a. From the Logical list, select one of these operators:
DescriptionLogical Operator
Requires that all expressions in the rule evaluate to true for the rule to be
considered true and trigger a warning level or action
AND
Requires that only one of the expressions in the rule evaluate to true for the
rule to be considered true and trigger a warning level or action
OR
If you do not select an operator, the default is AND.
b. From the Property list, select one of these compiler estimates to evaluate:
DescriptionCompiler Estimate
Estimated memory for the query
EST_TOTAL_MEMORY
Estimated time to execute the query
EST_TOTAL_TIME
Estimated total number of rows that the query will return
EST_CARDINALITY
Estimated total number of rows that will be accessed by all the scan, insert,
update, and delete operators
EST_ACCESSED_ROWS
Estimated total number of rows that will be accessed by scan and insert
operators
EST_USED_ROWS
Number of joins in the query plan
NUM_JOINS
Estimated number of rows that will be accessed by a full scan of a table
SCAN_SIZE
Missing statistics for a single-column group
UPD ATE_STATS_WARNING
Join without a predicate
CROSS_PRODUCT
c. If you selected UPDATE_STATS_WARNING or CROSS_PRODUCT, skip to step 7e.
From the Operator list, select one of these comparison operators:
• <>
• <=
• <
• =
• >=
• >
90 Configuring Rules