Neoview Workload Management Services Guide (R2.3)

• PRIORITY MEDIUM
• PRIORITY LOW-MEDIUM
• PRIORITY LOW
If you do not specify a priority, the default is MEDIUM.
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. This timeout value affects only new
incoming queries associated with the service and
not queries that are already 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. The default is 0, meaning no
timeout.
EXEC_TIMEOUT
query-timeout-value
specifies a timeout value for queries waiting to
execute in the service. This timeout value affects
only new incoming queries associated with the
service and not queries that are already waiting 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. 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
ALTER SERVICE Command 59