Neoview Workload Management Services Guide (R2.4)

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 ROLE.DBA or the super ID (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 }
wms-parameter
Specifies default values for a service anytime a new service is added using ADD SERVICE
command and service-parameters are unspecified. Also specifies SYSTEM service values.
May be one of the following:
Sets the default value to use when an ADD SERVICE command is
executed and this parameter is not specified. Range is 0 to 100 percent.
Zero (0) means this threshold is not checked.
MAX_CPU_BUSY max-cpu-busy
Sets the default value to use when an ADD SERVICE command is
executed and this parameter is not specified. Range is 0 to 100 percent.
Zero (0) means this threshold is not checked.
MAX_MEM_USAGE max-mem-usage
Sets the default value to use when an ADD SERVICE command is
executed and this parameter is not specified max-rows-fetched is
0 to 9223372036854775807. If it is unspecified, the value from WMS is
used. Zero (0) means no limit.
MAX_ROWS_FETCHED
max-rows-fetched
Sets the default value to use when an ADD SERVICE command is
executed and this parameter is not specified. Range is 0-1440 minutes.
When the timeout value is reached, WMS rejects the waiting query
and returns an error message. Zero (0) means no timeout.
WAIT_TIMEOUT
query-timeout-value
Sets the default value to use when an ADD SERVICE command is
executed and this parameter is not specified. Range is 0-1440 minutes
When the timeout value is reached, WMS cancels the executing query
and returns an error message. Zero (0) means no timeout.
EXEC_TIMEOUT
query-timeout-value
Sets the default value to use when an ADD SERVICE command is
executed and this parameter is not specified. Range is 0-1440 minutes.
When the timeout value is reached, WMS cancels or rejects the holding
query and returns an error message. Zero (0) means no timeout.
HOLD_TIMEOUT
query-timeout-value
Specifies the interval, in seconds, at which WMS collects runtime
statistics for all executing queries managed by the WMS. Range is 5
through 300 seconds.
STATS_INVERVAL stats-interval
Specifies the interval, in seconds, at which WMS applies execution
rules for each query, when applicable. Range is 60 through 3600
seconds. If not specified, the interval is 60 seconds by default.
RULE_INVERVAL rule-value
106 WMS Commands