Neoview Workload Management Services Guide (R2.4)
Figure 4-5 Evaluating the First Execution Rule Associated With the Service
Execution Rule List:
1. EXECRULE1
2. EXECRULE2
3. EXECRULE3
EXECRULE1 Expression:
USED_ROWS >= 10000
SERVICE1
vst104a.vsd
Neoview WMS
EXECRULE1 = FALSE
WMS checks the next
execution rule,
EXECRULE2.
Query Runtime Statistic:
USED_ROWS = 1567
RMS
WMS checks the next execution rule, EXECRULE2, associated with the service. Because the query
runtime statistic of 1567 used rows meets the criterion of the execution rule expression, WMS
considers the execution rule, EXECRULE2 to be true. See Figure 4-6.
Figure 4-6 Evaluating the Next Execution Rule Associated With the Service
Execution Rule List:
1. EXECRULE1
2. EXECRULE2
3. EXECRULE3
EXECRULE2 Expression:
USED_ROWS >= 1000
SERVICE1
vst104b.vsd
Neoview WMS
EXECRULE2 = TRUE
WMS sets a warning level
or cancels the query
depending on how the rule
is defined.
Query Runtime Statistic:
USED_ROWS = 1567
RMS
WMS sets a warning level or cancels the query depending on the definition of the execution rule
that evaluates to true. In the case of EXECRULE2, WMS sets the warning level to medium and
does not cancel the query. Because EXECRULE2 does not have an action, such as cancelling the
query, WMS evaluates the next execution rule, EXECRULE3, which evaluates to false.
To implement execution rules in WMS, see these sections:
• “Adding an Execution Rule” (page 61)
• “Associating Execution Rules With a Service” (page 64)
60 Configuring Rules