Neoview Workload Management Services Guide (R2.5)

STATUS WMS Command
The STATUS WMS command returns information from shared memory about the WMS system
configuration and the status of the system resources.
Syntax
STATUS WMS
Considerations
The STATUS WMS command returns these configuration and status values:
Table A-27 STATUS WMS Output
DescriptionData TypeColumn Name
State of WMS:
• INIT (for initialization)
• ACTIVE
• HOLD
• STOPPED
• SHUTDOWN
VARCHAR(9)STATE
Maximum percentage of CPU busy allowed. Zero means
that this threshold is not checked.
INTMAX_CPU_BUSY
Maximum percentage of memory usage allowed. Zero
means that this threshold is not checked.
INTMAX_MEM_USAGE
Maximum number of rows that can be returned by a query.
Zero means no limit.
LARGEINTMAX_ROWS_FETCHED
Timeout value, in minutes, for executing queries in a service.
Zero means no timeout.
INTEXEC_TIMEOUT
Timeout value, in minutes, for waiting queries in a service.
Zero means no timeout.
INTWAIT_TIMEOUT
Timeout value, in minutes, for holding queries in a service.
Zero means no timeout.
INTHOLD_TIMEOUT
Frequency, in seconds, at which WMS collects runtime
statistics for all executing queries being managed by WMS
INTSTATS_INTERVAL
Frequency, in seconds, at which WMS evaluates the
execution rules for a query
INTRULE_INTERVAL
Interval, in minutes, after a query starts executing when
WMS starts evaluating the execution rules
INTRULE_INTERVAL_QUERY_EXEC_TIME
Average disk I/O across the clusterFLOATDISK_IO
Average disk cache usage across the clusterFLOATDISK_CACHE
Average CPU busy across the clusterFLOATCPU_BUSY
Average memory usage across the clusterFLOATMEM_USAGE
ALL for all processes or SQL for SQL processes, such as
MXESP, MXOSRVR, and MXUDR
VARCHAR(3)OFNDR_PROCESS_TYPE
Frequency, in seconds, at which WMS retrieves sample data
from the System Offender
INTOFNDR_SAMPLE_INTERVAL
Number of CPUs per sampleINTOFNDR_SAMPLE_CPUS
Number of processes per segmentINTOFNDR_SAMPLE_CACHE
252 WMS Commands