Neoview Workload Management Services Guide (R2.4)

STATUS WMS SEGMENT STATS Command
The STATUS WMS SEGMENT STATS command returns aggregated statistics about the queries
running on one or all segments of the Neoview platform.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is ROLE.DBA or the super ID (super.services or super.super).
Syntax
STATUS WMS [SEGMENT segment-num ] STATS
segment-num
is the number of a segment on the Neoview platform. If you specify a segment number, the
command returns statistics for only the specified segment.
Considerations
• The STATUS WMS SEGMENT STATS command returns the following information:
Table A-29 STATUS WMS SEGMENT STATS Output
DescriptionData TypeColumn Name
Segment numberVARCHAR(4)SEGMENT
Total number of queries on this segmentINTTOTAL_QUERIES
Total number of executing queriesINTTOTAL_EXEC
Total number of waiting queriesINTTOTAL_WAIT
Total number of holding queriesINTTOTAL_HOLD
Total number of suspended queriesINTTOTAL_SUSPEND
Total number of rejected queriesINTTOTAL_REJECT
Total number of cancelled queriesINTTOTAL_CANCEL
Total number of completed queriesINTTOTAL_COMPLETE
Average execution time in secondsINTAVG_EXEC_SECS
Average waiting time in secondsINTAVG_WAIT_SECS
Average holding time in secondsINTAVG_HOLD_SECS
Average suspended time in secondsINTAVG_SUSPEND_SECS
Time when statistics collection startedVARCHAR(26)START_TIME
Examples
• This command displays statistics for all segments on the Neoview platform:
STATUS WMS STATS;
• This command displays statistics for segment 1 on the Neoview platform:
STATUS WMS SEGMENT 1 STATS;
STATUS WMS SEGMENT STATS Command 151