Neoview Workload Management Services Guide (R2.5)

ALTER SERVICE Command
The ALTER SERVICE command modifies the attributes of a service in the WMS configuration
on the Neoview platform.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is a user associated with ROLE.DBA, SUPER.SERVICES, or SUPER.SUPER.
Syntax
ALTER SERVICE service-name [ service-parameter-list ]
service-parameter-list is:
service-parameter[, service-parameter]...
service-parameter is:
{ priority | service-threshold | sql-defaults | output-option | comment }
priority is:
PRIORITY { URGENT | HIGH | MEDIUM-HIGH | MEDIUM | LOW-MEDIUM | LOW }
service-threshold is:
{ MAX_CPU_BUSY percentage }
| { MAX_MEM_USAGE percentage }
| { MAX_ROWS_FETCHED num-rows }
| { ACTIVE start-time-value TO end-time-value }
| { EXEC_TIMEOUT query-timeout-value }
| { WAIT_TIMEOUT query-timeout-value }
| { HOLD_TIMEOUT query-timeout-value }
sql-defaults is:
{ SQL_DEFAULTS "sql-string" }
output-option is:
{ PLAN | NO_PLAN }
| { TEXT | NO_TEXT }
comment is:
{ COMMENT "comment-string" }
service-name
is the name of an existing service for managing queries. service-name must exist in the
WMS configuration and cannot be the SYSTEM service.
priority
is the priority of this service relative to other services. priority can be one of these values
in order of descending priority:
• PRIORITY URGENT
• PRIORITY HIGH
• PRIORITY MEDIUM-HIGH
• PRIORITY MEDIUM
• PRIORITY LOW-MEDIUM
• PRIORITY LOW
NOTE: The service priority is not a runtime or process priority. The service priority serves
as a launch priority, determining when the queries in a service are launched from the waiting
queue into execution relative to other services. To set the process priorities, please contact
your HP Support representative for assistance.
ALTER SERVICE Command 199