Neoview Workload Management Services Guide (R2.3)

Altering the WMS System Configuration
Use the ALTER WMS command to alter the WMS system configuration (that is, the SYSTEM
service), which includes the maximum CPU busy, the maximum memory usage, and the refresh
interval for query runtime statistics.
• For MAX_CPU_BUSY, specify a percentage for the maximum CPU busy of all CPUs on the
system. The default value is zero, meaning that WMS uses the internal value of 100 percent.
• For MAX_MEM_USAGE, specify a percentage for the maximum memory usage on the
system. The default value is zero, meaning that WMS uses the internal value of 85 percent.
• For STATS_INTERVAL, specify an interval in seconds at which WMS collects runtime
statistics for all executing queries managed by WMS. The value must be greater than or
equal to five seconds and less than or equal to 300 seconds. The default value is five seconds.
For example, in NCI, this ALTER WMS command changes the MAX_CPU_BUSY and
MAX_MEM_USAGE of the WMS system configuration:
NS%alter wms max_cpu_busy 80, max_mem_usage 90;
--- WMS operation complete.
NS%
For the syntax, see the “ALTER WMS Command” (page 60). You can also execute the ALTER
WMS command in JDBC and ODBC client applications. For more information, see “How to
Execute WMS Commands in NCI” (page 55).
Displaying the WMS System Configuration
The INFO WMS command displays information about the WMS system configuration:
A percentage representing the maximum CPU busy of all CPUs on the system. If INFO
WMS displays zero in the output, it means that WMS uses the internal value of 100
percent.
MAX_CPU_BUSY
A percentage representing the maximum memory usage on the system. If INFO WMS
displays zero in the output, it means that WMS uses the internal value of 85 percent.
MAX_MEM_USAGE
An interval in seconds at which WMS collects runtime statistics for all executing queries
managed by WMS. The default value is five seconds.
STATS_INTERVAL
For example, in NCI, this INFO WMS command displays information about the WMS system
configuration:
NS%info wms;
MAX_CPU_BUSY MAX_MEM_USAGE STATS_INTERVAL
------------ ------------- --------------
0 0 5
--- WMS operation complete.
NS%
The zeros for the MAX_CPU_BUSY and MAX_MEM_USAGE mean that WMS is using the
internal default values of 100% and 85%, respectively.
For the syntax, see the“INFO WMS Command” (page 65). You can also execute the INFO WMS
command in JDBC and ODBC client applications. For more information, see “How to Execute
WMS Commands in NCI” (page 55).
34 Configuring WMS