Neoview Workload Management Services Guide (R2.4)

the WAITING state. If a query is in the HOLDING state, you must manually release the
query to allow it to start executing.
For information on compilation rules, see “Compilation Rules” (page 51).
When the query starts executing, WMS proceeds with the “Execution Phase” (page 22).
Execution Phase
When a query has been executing for at least 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 at least 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.
See Figure 1-6 (page 23) for a diagram showing how WMS applies execution rules to an
executing query.
22 Introduction