Neoview Workload Management Services Guide (R2.5)

Table A-26 STATUS SERVICE SEGMENT STATS Output (continued)
DescriptionData TypeColumn Name
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).
Examples
• This command displays query counts and average times for all services on all segments of
the Neoview platform:
STATUS SERVICE STATS;
• This command displays query counts and average times for SERVICE1 on all segments of
the Neoview platform:
STATUS SERVICE SERVICE1 STATS;
• This command displays query counts and average times for all services on each segment of
the Neoview platform:
STATUS SERVICE STATS DETAIL;
• This command displays query counts and average times for SERVICE1 on each segment of
the Neoview platform:
STATUS SERVICE SERVICE1 STATS DETAIL;
• This command displays query counts and average times for all services on segment 1 of the
Neoview platform:
STATUS SERVICE SEGMENT 1 STATS;
• This command displays query counts and average times for the SERVICE1 on segment 1 of
the Neoview platform:
STATUS SERVICE SERVICE1 SEGMENT 1 STATS;
STATUS SERVICE SEGMENT STATS Command 251