Neoview Workload Management Services Guide (R2.4)

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 ROLE.DBA or the super ID (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 | 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 }
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
ALTER SERVICE Command 101