Neoview Workload Management Services Guide (R2.5)

output-option
specifies one of these options for storing information about the queries executing in the
service:
Collects the execution plans of queries executing in the service so that
client tools can use and display the query plans. If not specified, the
default is NO_PLAN, meaning that no plans are collected.
Use the STATUS QUERY PLAN command to get the query execution
plan of the specified query.
PLAN
Does not collect the execution plans of queries executing in the service.
The default is NO_PLAN, meaning that no plans are collected.
NO_PLAN
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 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
These ADD SERVICE commands define services that have difference system resource thresholds
for high, medium, and low priorities:
• This command adds a service, SERVICE1, to the WMS configuration:
ADD SERVICE SERVICE1
PRIORITY HIGH,
MAX_CPU_BUSY 100,
MAX_MEM_USAGE 100,
ACTIVE 00:00 TO 24:00,
EXEC_TIMEOUT 120,
WAIT_TIMEOUT 720,
HOLD_TIMEOUT 1440,
COMMENT "Created by DBA on 5/14/2010";
SERVICE1 has a high priority, allows a maximum CPU busy and memory usage of 100
percent, and has an active period of 24 hours. It has timeout values for executing queries
(two hours), waiting queries (12 hours), and holding queries (24 hours).
• This command adds a service, SERVICE2, to the WMS configuration:
ADD SERVICE SERVICE2
PRIORITY MEDIUM,
MAX_CPU_BUSY 100,
MAX_MEM_USAGE 85,
ACTIVE 08:00 TO 24:00,
EXEC_TIMEOUT 240,
WAIT_TIMEOUT 1440,
COMMENT "Created by DBA on 5/14/2010";
ADD SERVICE Command 187