Neoview Workload Management Services Guide (R2.4)

STOP SERVICE Command
The STOP SERVICE command stops a service.
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
STOP SERVICE service-name [ IMMEDIATE ]
service-name
service-name is the name of a 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.
IMMEDIATE
When specified, all waiting queries are rejected and all executing queries are cancelled. The
state of the service is changed to STOPPING. When all the executing queries are cancelled,
the state is changed to STOPPED. No new query requests are allowed into the service.
When IMMEDIATE is not specified, waiting queries are rejected and executing queries are
allowed to complete executing. The state of the service is changed to STOPPING. When all
the executing queries complete executing, the state of the service is changed to STOPPED.
No new query requests are allowed into the service.
Considerations
• The STOP SERVICE command rejects queries that a compilation rule put on hold or waiting
queries that the HOLD command put on hold.
• The STOP SERVICE command does not cancel queries that were put on hold while executing.
Examples
• This command stops SERVICE1:
STOP SERVICE SERVICE1;
STOP SERVICE Command 153