Neoview Workload Management Services Guide (R2.5)

Cancel a Query
NOTE: You must be an administrator to cancel queries.
You can cancel (or kill) a query to free system resources.
This table shows how the cancel operation affects waiting, holding, suspended, and executing
queries:
Table 6-3 Effect of the Cancel Operation
ActionWMS Operation
WMS rejects the query.CANCEL when QUERY_STATE = WAITING
WMS rejects the query.CANCEL when QUERY_STATE = HOLDING
WMS cancels the query without stopping the NDCS server.CANCEL when QUERY_STATE = SUSPENDED
WMS cancels the query without stopping the NDCS server.CANCEL when QUERY_STATE = EXECUTING
When you cancel an executing query, this SQL error message is returned to the client application
that issued the query:
ERROR[8007] The operation has been canceled.
The query is terminated, but the application remains connected to the Neoview platform.
When you cancel a waiting query, this message is returned to the client application that issued
the query:
Query Rejected-Query Canceled By Admin.
NOTE: If you cancel a query that is executing in a service where query statistics aggregation
is enabled, WMS tries to cancel the query. Usually, the query is cancelled immediately. However,
it can take up to the configured WMS_INTERVAL time for the query to be cancelled.
How to Cancel a Query
CAUTION: The Live View displays its own SQL statements in the query list. Any SQL operation
initiated by the Live View is identified by the text “Neoview Performance Analyzer” or “Neoview
Query Viewer” in the APPLICATION_ID field in the Live View. Any actions against such queries
are discouraged. For example, cancelling a query initiated by the Live View causes the Live View
to lose its ODBC connection to the Neoview platform.
To cancel one or more queries in WMS:
1. In the Live View pane, select the queries that you want to cancel.
2. Right-click one of the selected queries, and select Kill Selected Queries from the list.
Manage Queries 145