Neoview Workload Management Services Guide (R2.5)

6. If you want WMS to cancel the query when the rule evaluates to true, select CANCEL from
the Action list.
NOTE: You must specify CANCEL is you specify NO-WARN for the warning level.
WMS immediately cancels the query. When the query is cancelled, any uncommitted work
is automatically rolled back.
7. Specify one to fifteen execution rule expressions to define the conditions that must be met
for the execution 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 query runtime statistics to evaluate:
DescriptionQuery Runtime Statistic
Number of rows returned to the query
USED_ROWS
Number of rows accessed by the query
ACCESSED_ROWS
Total memory used to process the query
TOTAL_MEM_ALLOC
Elapsed time of the query execution. This is the time since the start of the
query execution until the current time and includes any time that the query
spent in the waiting, holding, or suspended state.
ELAPSED_TIME
Amount of processor (CPU) time used by Neoview SQL for the query
IMPORTANT: If you select this option, be aware that the query cost model,
which influences the CPU time, might change in the future.
CPU_TIME
c. From the Operator list, select one of these comparison operators:
• %• <>
• <=
• <
• =
• >=
• >
d. If you selected % for the operator, enter a value from 100 to 1000 in the Percentage box.
When WMS evaluates the execution rule, it checks if the first operand of the expression
(from the Property list) is greater than the second operand (from the Value box) by this
percentage.
104 Configuring Rules