Neoview Workload Management Services Guide (R2.3)

For example, in NCI, this INFO SERVICE command displays configuration information for all
services in WMS:
NS%info service all;
SERVICE_NAME SERVICE_PRIORITY MAX_CPU_BUSY MAX_MEM_USAGE ACTIVE_TIME
SQL_PLAN SQL_TEXT EXEC_TIMEOUT WAIT_TIMEOUT COMMENT
-------------------------------------------------- ---------------- ------------ -------------
-------------------------------------------------- -------- -------- ------------ ------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------
HP_DEFAULT_SERVICE LOW 0 0 FROM 00:00 TO
23:59 NO_PLAN NO_TEXT 0 0 DEFAULT SERVICE
SERVICE1 MEDIUM 0 0 FROM 00:00 TO
23:59 NO_PLAN NO_TEXT 0 0
--- WMS operation complete.
NS%
This INFO SERVICE command in NCI displays configuration information for the
HP_DEFAULT_SERVICE service:
NS%info service hp_default_service;
SERVICE_NAME SERVICE_PRIORITY MAX_CPU_BUSY MAX_MEM_USAGE ACTIVE_TIME
SQL_PLAN SQL_TEXT EXEC_TIMEOUT WAIT_TIMEOUT COMMENT
-------------------------------------------------- ---------------- ------------ -------------
-------------------------------------------------- -------- -------- ------------ ------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------
HP_DEFAULT_SERVICE LOW 0 0 FROM 00:00 TO
23:59 NO_PLAN NO_TEXT 0 0 DEFAULT SERVICE
--- WMS operation complete.
NS%
For the syntax, see the “INFO SERVICE Command” (page 64). You can also execute the INFO
SERVICE command in JDBC and ODBC client applications. For more information, see “How to
Execute WMS Commands in NCI” (page 55).
Configuring the WMS System Configuration
WMS has a built-in system configuration that defines the maximum CPU busy, maximum memory
usage, and statistics collection interval for the cluster. As a database administrator, you can alter
these attributes of the WMS system configuration:
The percentage from zero to 100 of the total CPU busy allowed for the system. This
value is an average of CPU busy across all segments in the cluster. If you do not set
this threshold, the default is zero, meaning that WMS uses the internal default value
of 100%.
MAX_CPU_BUSY
The percentage from zero to 100 of memory usage allowed for the system. This value
is an average of memory usage across all segments in the cluster. If you do not set this
threshold, the default is zero, meaning that WMS uses the internal default value of 85%
.
MAX_MEM_USAGE
An interval in seconds at which WMS collects runtime statistics for all executing queries
managed by WMS. The default is five seconds.
STATS_INTERVAL
To change the attributes of the WMS system configuration, use the ALTER WMS command. See
.
Configuring the WMS System Configuration 33