Neoview Workload Management Services Guide (R2.5)

Release a Query
NOTE: You must be an administrator to release queries.
You can put a query that was put on hold back into the executing or waiting state by performing
a release operation.
This table shows how the release operation affects holding queries:
Table 6-2 Effect of the Release Operation
ActionWMS Operation
The query enters the WAITING state, and WMS checks the system
resources. If system resources are unavailable, the query remains
in the WAITING state. If system resources are available, the query
enters the EXECUTING state.
RELEASE when QUERY_STATE = HOLDING
The query starts executing.RELEASE when QUERY_STATE = SUSPENDED
How to Release a Query
To release one or more queries that were put on hold in WMS:
1. In the Live View pane, select the queries that you want to release.
2. Right-click one of the selected queries, and select Release Selected Queries from the list.
3. When prompted to confirm the release, click [OK].
Internally, WMS performs a RELEASE command on the selected queries. In the Live View, the
released queries are shown in blue or green text depending on their QUERY_STATE.
NOTE: You can also perform this task using the RELEASE QUERY or RELEASE QUERIES
SERVICE command. For more information, see the “RELEASE Command” (page 225).
144 Monitoring and Managing Workloads