Neoview Workload Management Services Guide (R2.5)

For information on compilation rules, see “Compilation Rules” (page 84).
When the query starts executing, WMS proceeds with the “Execution Phase” (page 26).
Execution Phase
When a query has been executing for a configured interval (by default, five minutes), WMS starts
periodically checking the execution rules set for the service against the query runtime statistics
to determine whether the query can continue executing.
Figure 1-5 shows the sequence of events (designated by the numbers in the diagram) that occur
when execution rules are applied during the execution phase.
Figure 1-5 How Execution Rules Are Applied
vst101.vsd
Neoview Data Warehousing Platform
Neoview
Database
Runtime
Statistics
(RMS)
NDCS Server
Neoview
WMS
Client Application
Issuing a Query
Management Tool for
Monitoring WMS
6
2
1
7
5
4
3
1. WMS grants permission to the NDCS server to start executing the query.
2. The query starts executing in the Neoview database.
3. At regular intervals, WMS requests runtime statistics for the query from the Runtime
Manageability Services (RMS) feature.
4. RMS returns the query runtime statistics to WMS.
5. When the query has been executing for a configured interval (by default, five minutes),
WMS compares the query runtime statistics with the execution rules set for the service to
determine if the query can continue executing or if the query should be cancelled.
NOTE: If query statistics aggregation is enabled for the service, the execution rules are
applied to the aggregated statistics.
See Figure 1-6 (page 27) for a diagram showing how WMS applies execution rules to an
executing query.
26 Introduction