Neoview Workload Management Services Guide (R2.4)

Table 5-2 Effect of the RELEASE Command
ActionWMS Command
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 = HOLDING
and QUERY_SUBSTATE =
SUSPENDED_BY_ADMIN
Use the STATUS QUERIES or STATUS QUERY command to display the QUERY_STATE column,
which shows the current state of a query. For more information, see the “STATUS QUERIES
Command” (page 127) or “STATUS QUERY Command” (page 136).
Cancelling a Query
Use the CANCEL command to cancel a query or a set of queries in WMS to free system resources.
This CANCEL command cancels a specific query:
SQL>mode ns
NS%cancel query MXID01002020782212110119447606071000000015509ROLE.USR200_498_S1
+>;
--- WMS operation complete.
NS%
For the syntax, see the “CANCEL Command” (page 110).
This table shows how the CANCEL command affects waiting, holding, and executing queries:
Table 5-3 Effect of the CANCEL Command
ActionWMS Command
WMS rejects the query.CANCEL when QUERY_STATE = WAITING
WMS rejects the query.CANCEL when QUERY_STATE = HOLDING
The NDCS server stops, cancelling the query.CANCEL when QUERY_STATE = HOLDING
and QUERY_SUBSTATE =
SUSPENDED_BY_ADMIN
The NDCS server stops, cancelling the query.CANCEL when QUERY_STATE = EXECUTING
Use the STATUS QUERIES or STATUS QUERY command to display the QUERY_STATE column,
which shows the current state of a query. For more information, see the “STATUS QUERIES
Command” (page 127) or “STATUS QUERY Command” (page 136).
When you cancel an executing query, you stop the NDCS server that is handling the query, and
the client session terminates. If you cancel an executing query from a JDBC client application,
the JDBC driver returns this error message to the client application:
There was a problem reading from the server
The message header was not long enough
If you cancel an executing query from an ODBC client application, the ODBC driver returns this
error message to the client application:
Communication link failure. The server timed out or disappeared
When you cancel a waiting query, the driver returns this message to the client application:
Query Rejected-Query Canceled By Admin.
Managing Queries 79