Neoview Workload Management Services Guide (R2.3)

system-threshold
specifies one of these limits for the system:
specifies the maximum CPU busy, as a percentage,
for all the CPUs on the system. percentage can be
a number from 0 through 100. Zero, the default value,
means that WMS uses the internal value of 100
percent.
MAX_CPU_BUSY
percentage
sets the maximum memory usage, as a percentage,
for the entire system. percentage can be a number
from 0 through 100. Zero, the default value, means
that WMS uses the internal value of 85 percent.
MAX_MEM_USAGE
percentage
specifies the interval, in seconds, at which WMS
collects runtime statistics for all executing queries
managed by the WMS. time-value is a number
from 5 through 300. If not specified, the interval is
five seconds by default.
STATS_INVERVAL
time-value
Considerations
To execute this command in NS mode in NCI, see “How to Execute WMS Commands in NCI”
(page 55).
Examples
• 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 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
CANCEL Command
The CANCEL command cancels a query or a set of queries being managed by WMS on the
Neoview platform.
Syntax
CANCEL type
type is:
{ QUERIES service-name [ ALL | state ]}
| { QUERIES { ALL | state } }
| { QUERY query-id }
state is:
{ EXECUTING | WAITING | HOLDING }
CANCEL Command 61