Neoview Workload Management Services Guide (R2.4)

Collects the SQL syntax of queries executing in the service so that client
tools can use and display the SQL syntax. If not specified, the default
is NO_TEXT, meaning that no SQL text is collected.
Use the STATUS QUERY TEXT command to get the query execution
plan of the specified query.
TEXT
Does not collect the SQL syntax of queries executing in the service.
The default is NO_TEXT, meaning that no SQL text is collected.
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 Altering a Service Affects Queries” (page 35).
• To alter the SYSTEM service, see the “ALTER WMS Command” (page 106).
Examples
• This command alters SERVICE50 to have MEDIUM-HIGH priority:
ALTER SERVICE SERVICE50 PRIORITY MEDIUM-HIGH;
• This command alters SERVICE50 to have a maximum CPU busy of 80 percent and a
maximum memory usage of 70 percent:
ALTER SERVICE SERVICE50 MAX_CPU_BUSY 80, MAX_MEM_USAGE 70;
ALTER SERVICE Command 103