Neoview Workload Management Services Guide (R2.4)
0 219 0 0 2009-04-12 10:36:20.838495
ALL SERVICE2
0 0 0 0 0 0 0 0
0 0 0 0 2009-04-12 10:36:20.838495
ALL SERVICE1
6 0 6 0 0 6 0 0
0 126 0 0 2009-04-12 10:36:20.838495
ALL SERVICE25
0 0 0 0 0 0 0 0
0 0 0 0 2009-04-12 10:36:20.838495
ALL SERVICE13
0 0 0 0 0 0 0 0
0 0 0 0 2009-04-12 10:36:20.838495
ALL SERVICE3
0 0 0 0 0 0 0 0
0 0 0 0 2009-04-12 10:36:20.838495
ALL SERVICE4
0 0 0 0 0 0 0 0
0 0 0 0 2009-04-12 10:36:20.838495
--- WMS operation complete.
NS%
For the syntax, see the “STATUS SERVICE SEGMENT STATS Command” (page 147).
Displaying Aggregated Statitics for Segments
This STATUS WMS STATS command displays aggregated statistics for all the segments of the
Neoview platform:
SQL>mode ns
NS%status wms stats;
SEGMENT TOTAL_QUERIES TOTAL_EXEC TOTAL_WAIT TOTAL_HOLD TOTAL_SUSPEND TOTAL_REJECT TOTAL_CANCEL TOTAL_COMPLETE
AVG_EXEC_SECS AVG_WAIT_SECS AVG_HOLD_SECS AVG_SUSPEND_SECS START_TIME
------- ------------- ----------- ----------- ----------- ------------- ------------ ------------ --------------
------------- ------------- ------------- ---------------- --------------------------
ALL 117 111 8 0 0 6 0
111 0 346 320584 0 2009-04-12 10:36:20.838495
--- WMS operation complete.
NS%
For the syntax, see the “STATUS WMS SEGMENT STATS Command” (page 151).
Resetting the Aggregated Statistics Counter
WMS continues to accumulate aggregated statistics about the queries in WMS until you run the
ALTER WMS RESET STATS command. The ALTER WMS RESET STATS command resets the
aggregated statistics counters to zero and resets the start time. WMS starts accumulating new
aggregated statistics from the time of the reset.
This ALTER WMS RESET STATS command resets the accumulated statistics to zero:
SQL>mode ns
NS%status wms stats;
SEGMENT TOTAL_QUERIES TOTAL_EXEC TOTAL_WAIT TOTAL_HOLD TOTAL_SUSPEND TOTAL_REJECT TOTAL_CANCEL TOTAL_COMPLETE
AVG_EXEC_SECS AVG_WAIT_SECS AVG_HOLD_SECS AVG_SUSPEND_SECS START_TIME
------- ------------- ----------- ----------- ----------- ------------- ------------ ------------ --------------
------------- ------------- ------------- ---------------- --------------------------
ALL 117 111 8 0 0 6 0
111 0 346 320584 0 2009-04-12 10:36:20.838495
--- WMS operation complete.
NS%alter wms reset stats;
--- WMS operation complete.
NS%status wms stats;
SEGMENT TOTAL_QUERIES TOTAL_EXEC TOTAL_WAIT TOTAL_HOLD TOTAL_SUSPEND TOTAL_REJECT TOTAL_CANCEL TOTAL_COMPLETE
AVG_EXEC_SECS AVG_WAIT_SECS AVG_HOLD_SECS AVG_SUSPEND_SECS START_TIME
------- ------------- ----------- ----------- ----------- ------------- ------------ ------------ --------------
------------- ------------- ------------- ---------------- --------------------------
ALL 0 0 0 0 0 0 0
0 0 0 0 0 2009-05-27 12:36:59.414343
--- WMS operation complete.
NS%
70 Managing Workload