Neoview Workload Management Services Guide (R2.4)

service-threshold
specifies one of these limits for the service:
Specifies the maximum percentage of CPU busy for the service,
averaged across all CPUs, that can be reached before WMS stops
allowing queries associated with the service to execute. When this
maximum is reached, all new queries associated with the service go
into the WAITING state. The range is 0 to 100 percent. Zero means this
threshold is not checked. If not specified, the service uses the value set
for the WMS system configuration. By default, this value is 100%.
MAX_CPU_BUSY percentage
Specifies the maximum percentage of memory usage, averaged across
all CPUs, that can be reached before WMS stops allowing queries
associated with the service to execute. When this maximum is reached,
all new queries associated with the service go into the WAITING state.
The range is 0 to 100 percent. Zero means this threshold is not checked.
If not specified, the service uses the value set for the WMS system
configuration. By default, this value is 85%.
MAX_MEM_USAGE percentage
Specifies the maximum number of rows that can be returned for the
query. The range is 0 to 9223372036854775807. Zero means no limit. If
not specified, the service uses the value set for the WMS system
configuration. By default, this value is 0 (no limit).
MAX_ROWS_FETCHED num-rows
Sets a start and end time range during which the service executes
queries. The 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
24:00.
ACTIVE start-time-value TO
end-time-value
Specifies a timeout value for queries executing in the service. When
the timeout value is reached, WMS cancels the executing query by
stopping the NDCS server. query-timeout-value can be a number
from 0 through 1440 minutes. Zero means no timeout. If not specified,
the service uses the value set for the WMS system configuration. By
default, this value is 0 (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 rejects the waiting query
and returns an error message. query-timeout-value can be a
number from 0 through 1440 minutes. Zero means no timeout. If not
specified, the service uses the value set for the WMS system
configuration. By default, this value is 0 (no timeout).
WAIT_TIMEOUT
query-timeout-value
Specifies a timeout value for keeping a query in a holding state. When
the timeout value is reached, WMS cancels or rejects the holding query
and returns an error message. query-timeout-value can be a
number from 0 through 1440 minutes. Zero means no timeout. If not
specified, the service uses the value set for the WMS system
configuration. By default, this value is 0 (no timeout).
HOLD_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 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
92 WMS Commands