Neoview Workload Management Services Guide (R2.5)

You can put a query that is on hold back into the executing or waiting state by performing a
release operation.
If you use the hold operation on an executing query, the operation suspends the query, suspending
all executor processes in which the query is running. However, if the query is running in a
transaction that might have pinned the audit trail, or if the transaction might be holding row or
file locks, the hold operation returns an error (8670 or 8671), and any process that was suspended
while processing the hold operation will be reactivated.
NOTE: You cannot suspend queries that are executing in a service where query statistics
aggregation is enabled.
This table shows how the hold operation affects waiting and executing queries:
Table 6-1 Effect of the Hold Operation
Resulting Query StateActionWMS Operation
QUERY_STATE = HOLDINGWMS puts the query on hold.HOLD when QUERY_STATE =
WAITING
QUERY_STATE = SUSPENDEDWMS suspends the query.HOLD when QUERY_STATE =
EXECUTING
How to Hold a Query
To hold one or more queries in WMS:
1. In the Live View pane, select the queries that you want to hold.
2. Right-click one of the selected queries, and select Hold Selected Queries from the list.
3. When prompted to confirm the hold, click [OK].
Internally, WMS performs a HOLD command on the selected queries. In the Live View, the held
queries are shown in gray text.
NOTE: You can also perform this task using the HOLD QUERY or HOLD QUERIES SERVICE
command. For more information, see the “HOLD Command” (page 212).
Manage Queries 143