Neoview Workload Management Services Guide (R2.4)

Altering a Service
Use the ALTER SERVICE command to alter these settings of a service:
• Priority
• System resource thresholds
• Active time of the service
• Query timeouts
• Maximum rows to retrieve
• Output options for the query plan and SQL text
• Comment
This ALTER SERVICE command changes the priority and active time of SERVICE13 in the WMS
configuration:
SQL>mode ns
NS%alter service service13 priority medium-high, active 08:00 to 13:00;
--- WMS operation complete.
NS%
For the syntax, see the “ALTER SERVICE Command” (page 101). Also see “How to Execute WMS
Commands in NCI” (page 25).
How Altering a Service Affects Queries
Whenever you alter a service, it is recommended that you do so when few or no queries associated
with that service are running on the Neoview platform. In case you alter a service when queries
associated with that service are running, be aware of the consequences. Table 3-2 shows how an
altered service attribute affects queries associated with the service.
Table 3-2 How an Altered Service Attribute Affects Queries Associated With the Service
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 to back into
the waiting or
executing state
YesNoPRIORITY
YesYes, when they are
released to back into
the waiting or
executing state
YesNoMAX_CPU_BUSY
YesYes, when they are
released to 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
Configuring User-Defined Services 35