Neoview Workload Management Services Guide (R2.4)

Figure 4-3 Evaluating the First Compilation Rule Associated With the Service
Compilation Rule List:
1. COMPRULE1
2. COMPRULE2
3. COMPRULE3
COMPRULE1 Expression:
EST_USED_ROWS > 50000
SERVICE1
vst103a.vsd
Neoview WMS
COMPRULE1 = FALSE
WMS checks the next
compilation rule,
COMPRULE2.
Compiler Estimate for the Query:
CMP_DP2_ROWS_USED = 33500
NDCS Server
WMS checks the next compilation rule, COMPRULE2, associated with the service. Because the
compiler estimate of 33,500 rows meets the criterion of the compilation rule expression, WMS
considers the compilation rule, COMPRULE2 to be true. See Figure 4-4.
Figure 4-4 Evaluating the Next Compilation Rule Associated With the Service
Compilation Rule List:
1. COMPRULE1
2. COMPRULE2
3. COMPRULE3
COMPRULE2 Expression:
EST_USED_ROWS > 25000
SERVICE1
vst103b.vsd
Neoview WMS
COMPRULE2 = TRUE
WMS sets a warning level
or performs an action on the
query depending on how the
rule is defined.
Compiler Estimate for the Query:
CMP_DP2_ROWS_USED = 33500
NDCS Server
WMS sets a warning level or performs an action on the query depending on the definition of the
compilation rule that evaluates to true. In the case of COMPRULE2, WMS sets the warning level
to medium and puts the query on hold. Because COMPRULE2 has an action, such as putting the
query on hold, WMS stops evaluating the compilation rules and does not evaluate the next
compilation rule, COMPRULE3.
To implement compilation rules in WMS, see these sections:
52 Configuring Rules