Neoview Workload Management Services Guide (R2.5)

Table 4-3 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
YesYes, when they are
released back into
the waiting or
executing state
YesNoMAX_MEM_USAGE
YesYes, when they are
released back into
the waiting or
executing state
YesNoMAX_ROWS_FETCHED
YesYes, when they are
released back into
the waiting or
executing state
YesNoACTIVE
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
YesNoNoNoSQL_DEFAULTS
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.
Delete a Service
IMPORTANT: Before you can delete a service, the service must be in the STOPPED state, and
it must not be one of the system-created services. See “Stop a Service” (page 157).
To delete a stopped service from WMS:
1. Use either of these methods to open the Configure Workload Management Services dialog
box:
• Select Tools > Configure Workload Management Services from the menu bar.
• Click the toolbar icon:
Configure Workload Management
Services Icon
Configure WMS Services 63