Neoview Workload Management Services Guide (R2.4)

STATUS WMS Command
The STATUS WMS command returns information about the WMS system configuration and the
status of the system resources.
Syntax
STATUS WMS
Considerations
• The STATUS WMS command returns these configuration values:
Table A-26 STATUS WMS Configuration Values
DescriptionData TypeColumn Name
State of WMS: INIT (for initialization), ACTIVE, HOLD,
STOPPING, STOPPED, or STOP
VARCHAR(9)STATE
Maximum CPU busy allowed. Zero (0) means no limit.INTMAX_CPU_BUSY
Maximum memory usage allowed. Zero (0) means no limit.INTMAX_MEM_USAGE
Maximum number of rows that can be returned.LARGEINTMAX_ROWS_FETCHED
Timeout value for executing queries in the serviceINTEXEC_TIMEOUT
Timeout value for waiting queries in the serviceINTWAIT_TIMEOUT
Timeout value before a holding query is cancelledINTHOLD_TIMEOUT
Interval at which WMS collects query runtime statisticsINTSTATS_INTERVAL
Frequency of invocation of execution rulesINTRULE_INTERVAL
• The STATUS WMS command returns this status information:
Table A-27 STATUS WMS Status Information
DescriptionData TypeColumn Name
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
Examples
• This command displays status information about WMS:
STATUS WMS;
STATUS WMS Command 149