Neoview Workload Management Services Guide (R2.5)

service-threshold
specifies one of these limits for the service:
Specifies the maximum percentage of CPU busy for the service,
averaged across all CPUs. 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 that 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. 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 that 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 accepts
incoming 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 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).
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 queries in the 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
SQL_DEFAULTS "sql-string"
is an SQL command string, which is issued when a client session connects to the Neoview
platform and is assigned to the service. You must delimit the SQL string in double quotes.
The string can contain multiple commands, but their combined length must not exceed 1024
bytes. Use semicolons to separate the commands, and end the last command with a semicolon
(;).
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
200 WMS Commands