Neoview Workload Management Services Guide (R2.5)

CANCEL Command
The CANCEL command cancels a query or a set of queries being managed by WMS on the
Neoview platform.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is a user associated with ROLE.DBA, SUPER.SERVICES, or SUPER.SUPER.
Syntax
CANCEL type
type is:
{ QUERIES SERVICE service-name [ ALL | state ]}
| { QUERIES { ALL | state } }
| { QUERY query-id }
state is:
{ EXECUTING | WAITING | HOLDING }
type
specifies one of these options for cancelling queries:
Cancels all queries in the specified service. service-name is the name
of an existing service for managing queries.
QUERIES SERVICE service-name
[ALL]
Cancels all queries in the specified query state in the specified service.
service-name is the name of an existing service for managing queries.
state is one of these query states:
• EXECUTING
• WAITING
• HOLDING
QUERIES SERVICE service-name
state
Cancels all queries.QUERIES ALL
Cancels all queries in the specified query state. state is one of these
query states:
• EXECUTING
• WAITING
• HOLDING
QUERIES state
Cancels the specified query. query-id is the query identifier and can
be a maximum of 160 characters.
QUERY query-id
Examples
• This command cancels all queries in SERVICE1:
CANCEL QUERIES SERVICE SERVICE1;
• This command cancels all queries in the executing state in SERVICE1:
CANCEL QUERIES SERVICE SERVICE1 EXECUTING;
• This command cancels all queries on the Neoview platform:
CANCEL QUERIES ALL;
• This command cancels all queries in the waiting state:
CANCEL QUERIES WAITING;
• This command cancels a specific query:
CANCEL QUERY MXID01002031074212110209169193275000000000609ROLE.USR200_73_S1;
208 WMS Commands