Neoview Workload Management Services Guide (R2.3)

5 Managing Workload in WMS
• “Monitoring System Resources” (page 41)
• “Monitoring Services and Queries” (page 41)
• “Managing Services” (page 51)
• “Managing Queries” (page 52)
Monitoring System Resources
Using the STATUS WMS Command to Monitor System Resources
In NCI, this STATUS WMS command displays information about the state of the system and the
system resources:
NS%status wms;
STATE MAX_CPU_BUSY MAX_MEM_USAGE STATS_INTERVAL DISK_IO DISK_CACHE CPU_BUSY
MEM_USAGE
--------- ------------ ------------- -------------- ------------------------ ------------------------
------------------------ ------------------------
ACTIVE 0 0 5 42.08 17.46
0.99 87.92
--- WMS operation complete.
NS%
For more information, see the “STATUS Command” (page 66).
Monitoring Services and Queries
• “Displaying the Status of Services” (page 41)
• “Displaying the Status and Compile-Time Statistics of All Queries” (page 43)
• “Displaying the Status and Compile-Time Statistics of Queries in a Service” (page 44)
• “Filtering the Status and Compile-Time Statistics of Queries” (page 44)
• “Displaying the Total Number of Executing Queries” (page 47)
• “Displaying Runtime Statistics of All Queries” (page 48)
• “Displaying Runtime Statistics of a Specific Query” (page 49)
• “Displaying the Query Explain Plan” (page 50)
• “Displaying the Query SQL Text” (page 50)
Displaying the Status of Services
Use the STATUS SERVICE command to display the status of services in WMS. The STATUS
SERVICE command displays this status information about the existing services in WMS:
Name of the serviceSERVICE_NAME
Activity state of the serviceSTATE
The priority of the service relative to other servicesSERVICE_PRIORITY
A percentage from zero to 100 of the total CPU busy allowed for the service. This
value is an average of CPU busy across all segments in the cluster. The default is
zero, meaning that WMS uses the threshold of the WMS system configuration, if
set, or the internal default threshold of 100%.
MAX_CPU_BUSY
A percentage from zero to 100 of memory usage allowed for the service. This value
is an average of memory usage across all segments in the cluster. The default is
zero, meaning that WMS uses the threshold of the WMS system configuration, if
set, or the internal default threshold of 85%.
MAX_MEM_USAGE
Monitoring System Resources 41