Neoview Workload Management Services Guide (R2.4)

HOLD Command
The HOLD command places a waiting or executing query or set of queries being managed by
WMS on hold. To cancel a query, see the “CANCEL Command” (page 110).
NOTE: Only administrators are permitted to run this command. By default, an administrator
is ROLE.DBA or the super ID (super.services or super.super).
Syntax
HOLD type
type is:
{ WMS }
| { SERVICE { service-name | ALL } }
| { QUERY { query-id | ALL } }
| { QUERIES SERVICE service-name }
type
specifies one of these options for holding queries:
Puts WMS in a HOLD state. Service and query states are not affected.
New queries are rejected.
WMS
Puts a service in the HOLD state. Queries remain in the state that they
were in before you put the service on hold, meaning that all waiting
queries continue waiting and all executing queries continue executing.
New queries are rejected.
service-name is the name of an existing user-defined service for
managing queries. service-name must exist in the WMS
configuration and cannot be the SYSTEM service. The service name is
not case-sensitive and is always converted to uppercase.
SERVICE service-name
Puts services in a HOLD state. Queries remain in the state that they
are in. New queries are rejected.
SERVICE ALL
Puts the specified query in a HOLDING state. query-id is the query
identifier and can be a maximum of 160 characters.
QUERY query-id
Puts all queries in a HOLDING state.QUERY ALL
Puts all queries in the specified service in a HOLDING state.
service-name is the name of an existing user-defined service for
managing queries. service-name must exist in the WMS
configuration and cannot be the SYSTEM service. The service name is
not case-sensitive and is always converted to uppercase.
QUERIES SERVICE service-name
Examples
• This command suspends all WMS activities and puts WMS in a holding state:
HOLD WMS;
• This command holds all waiting queries in SERVICE1:
HOLD SERVICE SERVICE1;
• This command holds all services on the Neoview platform:
HOLD SERVICE ALL;
• This command holds a specific waiting or executing query:
HOLD QUERY MXID01002031074212110209169193275000000000609ROLE.USR200_73_S1;
• This command holds all waiting or executing queries:
HOLD Command 113