Neoview Workload Management Services Guide (R2.4)

Table 3-2 How an Altered Service Attribute Affects Queries Associated With the Service (continued)
Do incoming queries
in the service use the
new attribute?
Do holding queries in
the service use the
new attribute?
Do waiting queries in
the service use the
new attribute?
Do executing queries
in the service use the
new attribute?Altered Service Attribute
Yes, when they start
executing
Yes, when they are
released back into the
waiting or executing
state
Yes, when they start
executing
No, not if they are
already executing
EXEC_TIMEOUT
Yes, when they are
put on hold
YesYes, when they are
put on hold
NoHOLD_TIMEOUT
Yes, when they are
put in the waiting
state
Yes, when they are
released back into the
waiting state
YesNoWAIT_TIMEOUT
YesNoNoNoPLAN | NO PLAN
YesNoNoNoTEXT | NO TEXT
When the new maximum CPU busy and maximum memory usage are less than the previous
values of the service, the lower thresholds cause waiting queries associated with the service to
stay in the waiting queue longer until resources become available. When the new maximum
CPU busy and maximum memory usage are greater than the previous values of the service, the
higher thresholds cause waiting queries associated with the service to start executing sooner
than they would have at lower thresholds.
Deleting a Service
IMPORTANT: To delete a service, the service must be in the STOPPED state. For more
information, see “Stopping a Service” (page 77).
Use the DELETE SERVICE command to delete a service from the WMS configuration. A service
must be in the STOPPED state before you can delete it. For more information, see “Stopping a
Service” (page 77).
When you issue a DELETE SERVICE command, the state of the deleted service changes from
active or hold to deleting. In the deleting state, WMS rejects all waiting queries and rejects all
incoming queries (that is, execution requests) associated with the service.
This DELETE SERVICE command removes SERVICE13 from the WMS configuration:
SQL>mode ns
NS%delete service service13;
--- WMS operation complete.
NS%
For the syntax, see the “DELETE SERVICE Command” (page 112). Also see “How to Execute
WMS Commands in NCI” (page 25).
Displaying Information About the Service Definitions
The STATUS SERVICE command displays information about the configuration of one or all
services in WMS.
This STATUS SERVICE command displays configuration information for all services in WMS:
SQL>mode ns
NS%status service all;
SERVICE_NAME STATE SERVICE_PRIORITY MAX_CPU_BUSY MAX_MEM_USAGE MAX_ROWS_FETCHED ACTIVE_TIME
SQL_PLAN SQL_TEXT EXEC_TIMEOUT WAIT_TIMEOUT HOLD_TIMEOUT
36 Configuring Services