Neoview Workload Management Services Guide (R2.3)

Managing Services
“Holding All Services” (page 51)
“Holding a Service” (page 51)
“Releasing All Services” (page 51)
“Releasing a Service” (page 51)
Holding All Services
When you hold all services in WMS, you prevent the waiting queries associated with all the
services from being executed. While the services are on hold, WMS allows queries that are
currently executing in the services to finish executing, but WMS rejects new incoming queries
associated with the services.
Use the HOLD SERVICE ALL command to hold all services in WMS. For example:
NS%hold service all;
--- WMS operation complete.
NS%
For the syntax, see the “HOLD Command” (page 63).
Holding a Service
When you hold a service in WMS, you prevent the waiting queries associated with the service
from being executed. While the service is on hold, WMS allows queries that are currently executing
in the service to finish executing, but WMS rejects new incoming queries associated with the
service.
Use the HOLD SERVICE command to hold the waiting queries of a specific service in WMS. For
example, this HOLD command holds all waiting queries in the DATALOADING service:
NS%hold service dataloading;
--- WMS operation complete.
NS%
For the syntax, see the “HOLD Command” (page 63).
Releasing All Services
To release all services that are currently being held in WMS, use the RELEASE SERVICE ALL
command. For example:
NS%release service all;
--- WMS operation complete.
NS%
For the syntax, see the “RELEASE Command” (page 66).
Releasing a Service
Use the RELEASE SERVICE command to release a service and all its queries, which are being
held in WMS. For example, this RELEASE command releases all holding queries in the
DATALOADING service:
NS%release service dataloading;
--- WMS operation complete.
NS%
Managing Services 51