Neoview Workload Management Services Guide (R2.4)

SERVICE1
COMP LOW COMPRULE3
1 EST_USED_ROWS > 1000
MXID01002010657212109516853678165000000115709ROLE.USR100_3616_S1
SERVICE1
EXEC MEDIUM EXECRULE2
1 USED_ROWS >= 1000
MXID01003031050212108224567420861000000331309ROLE.USR100_9972_S1
SERVICE1
COMP LOW COMPRULE3
1 EST_USED_ROWS > 1000
MXID01003020793212110131970645532000000013409ROLE.USR100_435_S1
SERVICE1
COMP LOW COMPRULE3
1 EST_USED_ROWS > 1000
MXID01003020793212110131970645532000000013409ROLE.USR100_435_S1
SERVICE1
EXEC MEDIUM EXECRULE2
1 USED_ROWS >= 1000
--- WMS operation complete.
NS%
For the syntax, see the “STATUS QUERIES Command” (page 127).
Managing Services
• “Holding Services” (page 76)
• “Releasing Services” (page 76)
• “Stopping a Service” (page 77)
• “Starting a Service” (page 77)
Holding Services
When you hold a service or all services in WMS, you cause waiting queries associated with the
service to be held and executing queries to stop executing.
Use the HOLD SERVICE command to hold queries of a specific service in WMS or the HOLD
SERVICE ALL command to hold queries in all services in WMS. This HOLD SERVICE command
places all queries in SERVICE1 on hold:
SQL>mode ns
NS%hold service service1;
--- WMS operation complete.
NS%
Use the HOLD SERVICE ALL command to hold all services in WMS:
NS%hold service all;
--- WMS operation complete.
NS%
For the syntax, see the “HOLD Command” (page 113).
Releasing Services
Use the RELEASE SERVICE command to release a specific service and all its queries, which are
being held by WMS, or use the RELEASE SERVICE ALL command to release all services and
their queries, which are being held by WMS. This RELEASE command releases all holding queries
in SERVICE1:
SQL>mode ns
76 Managing Workload