Neoview Workload Management Services Guide (R2.5)

Specifies the frequency, in seconds, at which WMS collects runtime
statistics for all executing queries being managed by WMS. Range is
5 through 300 seconds. If not specified, the interval is 5 seconds by
default.
STATS_INVERVAL stats-interval
Specifies the frequency, in seconds, at which WMS evaluates the
execution rules for a query. Range is 60 through 3600 seconds. If not
specified, the interval is 60 seconds by default.
RULE_INVERVAL rule-interval
Specifies the interval, in minutes, after a query starts executing when
WMS starts evaluating the execution rules. Range is 1 to 30 minutes.
If not specified, the interval is 5 minutes by default.
RULE_INTERVAL_QUERY_EXEC_TIME
start-interval
Considerations
• If you do not set a threshold when adding a service, WMS copies the default threshold value
from the WMS system configuration and stores it in the service definition.
• Altering the WMS system configuration after you add a service does not alter the threshold
values of the service. The service retains its original threshold values until you alter the
service.
Examples
• This command alters the system configuration to have a maximum CPU busy of 80% and
a maximum memory usage of 90%:
ALTER WMS MAX_CPU_BUSY 80, MAX_MEM_USAGE 90;
• This command alters the system configuration to have a statistics refresh interval of 10
seconds:
ALTER WMS STATS_INTERVAL 10;
• This command alters the system configuration so that WMS starts evaluating the execution
rules 20 minutes after a query starts executing:
ALTER WMS RULE_INTERVAL_QUERY_EXEC_TIME 20;
• This command alters the system configuration so that WMS evaluates the execution rules
for each query every 300 seconds (or five minutes):
ALTER WMS RULE_INTERVAL 300;
ALTER WMS Command 205