Neoview Workload Management Services Guide (R2.5)

ALTER WMS Command
The ALTER WMS command modifies the thresholds of the WMS system configuration on the
Neoview platform.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is a user associated with ROLE.DBA, SUPER.SERVICES, or SUPER.SUPER.
Syntax
ALTER WMS wms-parameter-list
wms-parameter-list is:
wms-parameter [ , wms-parameter ] ...
wms-parameter is:
{ MAX_CPU_BUSY max-cpu-busy }
| { MAX_MEM_USAGE max-mem-usage }
| { MAX_ROWS_FETCHED max-rows-fetched }
| { WAIT_TIMEOUT query-timeout-value }
| { EXEC_TIMEOUT query-timeout-value }
| { HOLD_TIMEOUT query-timeout-value }
| { STATS_INTERVAL stats-interval }
| { RULE_INTERVAL rule-interval }
| { RULE_INTERVAL_QUERY_EXEC_TIME start-interval }
wms-parameter
Changes one of the threshold values of the WMS system configuration. The parameters are
as follows:
Specifies the maximum percentage of CPU busy for a 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. By
default, this value is 100 percent.
MAX_CPU_BUSY max-cpu-busy
Specifies the maximum percentage of memory usage for a 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.
By default, this value is 85 percent.
MAX_MEM_USAGE max-mem-usage
Specifies the maximum number of rows that can be returned for the
query. The range is 0 to 9223372036854775807. Zero means no limit.
By default, this value is 0 (no limit).
MAX_ROWS_FETCHED
max-rows-fetched
Specifies a timeout value for queries waiting to execute in a 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. By
default, this value is 0 (no timeout).
WAIT_TIMEOUT
query-timeout-value
Specifies a timeout value for queries executing in a 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. By default, this value
is 0 (no timeout).
EXEC_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. By
default, this value is 0 (no timeout).
HOLD_TIMEOUT
query-timeout-value
204 WMS Commands