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 SQL syntax 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 you are creating. 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
• Use a unique name for the service. You cannot add a service that already exists.
• You cannot add a service named SYSTEM or HP_DEFAULT_SERVICE.
• You cannot add a service that begins with the reserved “HPS_” prefix or that has the same
name as one of the predefined services, HPS_TRANSPORTER and HPS_MANAGEABILITY.
Administrators can alter those predefined services.
Examples
• This command adds a service, SERVICE50, to the WMS configuration. SERVICE50 has
URGENT priority, allows a maximum CPU busy of 90 percent, and has an active period of
18:00 to 22:00:
ADD SERVICE SERVICE50 PRIORITY URGENT,
MAX_CPU_BUSY 90, ACTIVE 18:00 TO 22:00;
• This command gives SERVICE51 MEDIUM priority and adds a comment that says when
the service was created:
ADD SERVICE SERVICE51 PRIORITY MEDIUM,
COMMENT "Created on 5/14/2009";
ADD SERVICE Command 93