Neoview Workload Management Services Guide (R2.4)

5 Managing Workload
• “Monitoring System Resources” (page 69)
• “Monitoring Queries” (page 69)
• “Displaying Warning Information” (page 75)
• “Managing Services” (page 76)
• “Managing Queries” (page 78)
Monitoring System Resources
Use the STATUS WMS command to display information about the state of WMS and the system
resources:
SQL>mode ns
NS%status wms;
STATE MAX_CPU_BUSY MAX_MEM_USAGE MAX_ROWS_FETCHED EXEC_TIMEOUT WAIT_TIMEOUT HOLD_TIMEOUT STATS_INTERVAL
RULE_INTERVAL DISK_IO DISK_CACHE CPU_BUSY MEM_USAGE
--------- ------------ ------------- -------------------- ------------ ------------ ------------ --------------
------------- ------------------------ ------------------------ ------------------------ ------------------------
ACTIVE 100 85 0 0 0 0
5 60 1.25 72.32683563232422 8.666210174560547 91.66666412353516
--- WMS operation complete.
NS%
For more information, see the “STATUS WMS Command” (page 149).
Monitoring Queries
• “Displaying the Aggregated Statistics of Query Workloads” (page 69)
• “Displaying the Total Number of Executing Queries” (page 71)
• “Displaying the Compile-Time Statistics of Queries” (page 71)
• “Displaying the Runtime Statistics of Queries” (page 72)
• “Displaying the Explain Plan of a Query” (page 74)
• “Displaying the SQL Text of a Query” (page 74)
Displaying the Aggregated Statistics of Query Workloads
Use the STATUS SERVICE SEGMENT STATS or STATUS WMS SEGMENT STATS command
to display aggregated statistics about the queries running in WMS. The aggregated statistics
include the total number of queries in various states (executing, waiting, holding, and so on) and
the average execution, waiting, holding, and suspended times.
Displaying Aggregated Statistics for Services
This STATUS SERVICE STATS command displays aggregated statistics for all the services on
the Neoview platform:
SQL>mode ns
NS%status service stats;
SEGMENT SERVICE_NAME
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 HPS_MANAGEABILITY
0 0 0 0 0 0 0 0
0 0 0 0 2009-04-12 10:36:20.838495
ALL HPS_TRANSPORTER
0 0 0 0 0 0 0 0
0 0 0 0 2009-04-12 10:36:20.838495
ALL HP_DEFAULT_SERVICE
111 111 2 0 0 0 0 111
Monitoring System Resources 69