Neoview Workload Management Services Guide (R2.3)

service-threshold
specifies one of these limits for the service:
specifies the maximum CPU busy, as a percentage,
of all the CPUs on the system for queries executing
in the service. percentage can be a number from
0 through 100. Zero, the default value, means that
WMS uses the threshold of the WMS system
configuration, if set, or the internal default threshold
of 100%.
MAX_CPU_BUSY
percentage
specifies the maximum memory usage, as a
percentage, of the entire system for queries executing
in the service. percentage can be a number from
0 through 100. Zero, the default value, means that
WMS uses the threshold of the WMS system
configuration, if set, or the internal default threshold
of 85%.
MAX_MEM_USAGE
percentage
sets a start and end time range during which the
service executes queries. time-value is hh:mm,
where hh is a value for the hour and mm is a value
for minutes. The active time cannot span more than
one day. If not specified, the service is always active
from 00:00 through 23:59.
ACTIVE time-value TO
time-value
specifies a timeout value for queries executing in
the service. When the timeout value is reached,
WMS cancels the executing query and stops the
NDCS server. query-timeout-value can be a
number from 0 through 1440 minutes. If not
specified, the default is 0, meaning no timeout.
EXEC_TIMEOUT
query-timeout-value
specifies a timeout value for queries waiting to
execute in the service. When the timeout value is
reached, WMS cancels the waiting query and returns
an error message. query-timeout-value can be
a number from 0 through 1440 minutes. If not
specified, the default is 0, meaning no timeout.
WAIT_TIMEOUT
query-timeout-value
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, such as NCI and the
Neoview Manageability Repository, can use and
display that data. If not specified, the default is
NO_PLAN, meaning that no plans are collected.
PLAN
does not collect the execution plans of queries
executing in the service. The default is NO_PLAN.
NO_PLAN
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 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.
ADD SERVICE Command 57