Neoview Workload Management Services Guide (R2.5)

Collects the SQL text of queries executing in the service so that client
tools can use and display the SQL text. If not specified, the default is
NO_TEXT, meaning that no SQL text is collected.
Use the STATUS QUERY TEXT command to get the SQL text of the
specified query.
TEXT
Does not collect the SQL text 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 62).
• To alter the SYSTEM service (that is, the WMS system configuration), see the “ALTER WMS
Command” (page 204).
Examples
• This command alters SERVICE1 to have medium-high priority:
ALTER SERVICE SERVICE1 PRIORITY MEDIUM-HIGH;
• This command alters SERVICE2 to have a maximum CPU busy of 80 percent and a maximum
memory usage of 70 percent:
ALTER SERVICE SERVICE2 MAX_CPU_BUSY 80, MAX_MEM_USAGE 70;
• This command alters SERVICE3 so that it issues two SQL commands when a client session
connects to the Neoview platform and is assigned to the service:
ALTER SERVICE SERVICE3 SQL_DEFAULTS "CONTROL QUERY DEFAULT
ISOLATION_LEVEL 'READ UNCOMMITTED'; CONTROL QUERY DEFAULT
ISOLATION_LEVEL_FOR_UPDATES 'READ UNCOMMITTED';";
ALTER SERVICE Command 201