Neoview Workload Management Services Guide (R2.5)
STOP WMS Command
The STOP WMS command stops WMS and all its services and rejects all waiting and incoming
queries in WMS.
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
STOP WMS [ IMMEDIATE ]
IMMEDIATE
causes all waiting queries to be rejected and all executing queries to be cancelled. The state
of WMS changes to STOPPING. When all executing queries have been cancelled, the state
changes to STOPPED. Any new requests to execute queries are rejected.
If you do not specify this option, WMS performs a graceful stop: waiting queries are rejected,
and executing queries are allowed to complete execution. When all executing queries have
been cancelled, the state changes to STOPPED. Any new requests to execute queries are
rejected.
Considerations
• Only administrators are permitted to run this command. By default, an administrator is a
user associated with ROLE.DBA, SUPER.SERVICES, or SUPER.SUPER.
• To stop the WMS system, it must be in the ACTIVE or HOLD state.
• Stopping the WMS system does not stop any internal WMS processes; it just stops WMS
from accepting new queries. To stop the internal WMS processes, contact your HP Support
representative for assistance.
Examples
• This command causes WMS to stop gracefully, allowing all executing queries to finish
executing:
STOP WMS;
• This command causes WMS to stop immediately, causing all executing queries to be cancelled
immediately:
STOP WMS IMMEDIATE;
260 WMS Commands