Neoview Workload Management Services Guide (R2.5)

STOP SERVICE Command
The STOP SERVICE command stops a service.
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 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 finish executing. The state of the service is changed to STOPPING. When all the
executing queries finish 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, allowing all executing queries to finish executing:
STOP SERVICE SERVICE1;
• This command stops SERVICE1 immediately, causing all executing queries in the service
to be cancelled immediately:
STOP SERVICE SERVICE1 IMMEDIATE;
STOP SERVICE Command 259