Neoview Workload Management Services Guide (R2.4)

NS%release service service1;
--- WMS operation complete.
NS%
For the syntax, see the “RELEASE Command” (page 125).
This RELEASE SERVICE ALL command releases all holding queries in all services:
NS%release service all;
--- WMS operation complete.
NS%
For the syntax, see the “RELEASE Command” (page 125).
Stopping a Service
To stop a service in the ACTIVE or HOLD state and put the service in the STOPPED state, use
the STOP SERVICE command. Issue a STOP SERVICE command before you delete a service
because a service that is not in the STOPPED state cannot be deleted.
When you issue the STOP SERVICE command with the IMMEDIATE option, WMS rejects all
waiting queries, cancels all executing queries, and changes the state of the service to STOPPING.
Once all the executing queries have been cancelled, WMS changes the state of the service to
STOPPED. WMS rejects incoming requests to execute queries.
If you do not specify IMMEDIATE, WMS rejects all waiting queries yet allows executing queries
to complete executing, changing the state of the service to STOPPING. Once all executing queries
complete executing, WMS changes the state of the service to STOPPED. WMS rejects incoming
requests to execute queries.
This STOP SERVICE command stops SERVICE1 with the IMMEDIATE option, causing all
executing queries to be immediately cancelled:
SQL>mode ns
NS%stop service service1 immediate;
--- WMS operation complete.
NS%
For the syntax, see“STOP SERVICE Command” (page 153).
Starting a Service
To start a service that is in the STOPPED state, use the START SERVICE command. This command
changes the state of the service from STOPPED to ACTIVE or HOLD, depending on the active
period of the service. Use the START SERVICE command after you have issued the STOP SERVICE
command.
This START SERVICE command starts SERVICE1:
SQL>mode ns
NS%start service service1;
--- WMS operation complete.
NS%
For the syntax, see “START SERVICE Command” (page 126).
Managing Services 77