Neoview Workload Management Services Guide (R2.4)

ADD SERVICE Command
The ADD SERVICE command adds a service to 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
ADD 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 a service for managing queries. service-name can be a maximum of 24
characters and must be a unique name in WMS. The service name is not case-sensitive and
is always converted to uppercase. WMS supports multibyte characters in the service name.
For guidelines on using multibyte character sets, see the Neoview Character Sets Administrator's
Guide.
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
If you do not specify a priority, the default is MEDIUM. For more information about setting
priorities, see “How WMS Determines When to Execute Waiting Queries” (page 28).
ADD SERVICE Command 91