README for HP Neoview Release 2.4 Service Pack 1

Table 3 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
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
How often, in seconds, 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
• In previous releases, only administrators (ROLE.DBA, super.services, and super.super by
default) could execute the following commands. Now, any user can execute these commands:
— STATUS WMS DETAIL
— STATUS WMS VERSION
• In previous releases, the STATUS WMS DETAIL command was not exposed to customers.
Now, any user can execute that command. For more information, see the “STATUS WMS
DETAIL Command” (page 16) below.
STATUS WMS DETAIL Command
The STATUS WMS DETAIL command displays information about CPU and memory consumption
per segment and per node.
Syntax
STATUS WMS DETAIL
Considerations
The STATUS WMS DETAIL command displays this information:
16