Neoview Workload Management Services Guide (R2.3)

collects the SQL syntax of queries executing in the
service so that client tools, such as NCI and the
Neoview Manageability Repository, can use and
display that data. If not specified, the default is
NO_TEXT, meaning that no SQL text is collected.
TEXT
does not collect the SQL syntax of queries executing
in the service. The default is NO_TEXT.
NO_TEXT
comment
is optional text that you can specify to describe the service that you
are altering. comment-string cannot exceed 256 characters. In
addition to alphanumeric characters, the comment can include dashes,
periods, underscores, and spaces. You must delimit the comment in
double quotes.
Considerations
• Altering a service might affect existing queries associated with the service. For more
information, see “How an Altered Service Affects Queries” (page 31).
• You cannot alter the SYSTEM service with the ALTER SERVICE command. Instead, use the
ALTER WMS command. For more information, see “ALTER WMS Command” (page 60).
• You cannot alter the priority or active time of HP_DEFAULT_SERVICE.
• To execute this command in NS mode in NCI, see “How to Execute WMS Commands in
NCI” (page 55).
Examples
• This command alters the DATALOADING service to have MEDIUM-HIGH priority:
ALTER SERVICE dataloading PRIORITY MEDIUM-HIGH
• This command alters the SALESQUERIES service to have a maximum CPU busy of 80
percent and a maximum memory usage of 70 percent:
ALTER SERVICE salesqueries MAX_CPU_BUSY 80, MAX_MEM_USAGE 70
ALTER WMS Command
The ALTER WMS command modifies the thresholds of the WMS system configuration (that is,
the SYSTEM service) on the Neoview platform.
Syntax
ALTER WMS system-threshold[, system-threshold]...
system-threshold is:
{ MAX_CPU_BUSY percentage }
| { MAX_MEM_USAGE percentage }
| { STATS_INTERVAL time-value }
60 WMS Commands