Neoview Workload Management Services Guide (R2.5)

STATUS WMS SEGMENT STATS Command
The STATUS WMS SEGMENT STATS command returns running counts and average times of
the queries on one or all segments of the Neoview platform. The command returns the total
number of queries in various states (executing, waiting, holding, and suspended) and their
average execution, waiting, holding, and suspended times.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is a user associated with ROLE.DBA, 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 query counts and average times for only the specified segment.
Considerations
• The STATUS WMS SEGMENT STATS command returns the following information:
Table A-30 STATUS WMS SEGMENT STATS Output
DescriptionData TypeColumn Name
Segment numberVARCHAR(4)SEGMENT
Cumulative number of queries on this segment since the start of
statistics collection
INTTOTAL_QUERIES
Cumulative number of queries that were in the executing state
since the start of statistics collection
INTTOTAL_EXEC
Cumulative number of queries that were in the waiting state
since the start of statistics collection
INTTOTAL_WAIT
Cumulative number of queries that were in the holding state
since the start of statistics collection
INTTOTAL_HOLD
Cumulative number of queries that were in the suspended state
since the start of statistics collection
INTTOTAL_SUSPEND
Cumulative number of queries that were rejected since the start
of statistics collection
INTTOTAL_REJECT
Cumulative number of queries that were cancelled since the start
of statistics collection
INTTOTAL_CANCEL
Cumulative number of queries that completed since the start of
statistics collection
INTTOTAL_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
• WMS continues accumulating running counts and average times of the queries until you
reset the counters. To reset the counters to zero, use the “ALTER WMS RESET STATS
Command” (page 207).
256 WMS Commands