Neoview Workload Management Services Guide (R2.4)

SQL>mode ns
NS%alter wms max_cpu_busy 95, max_mem_usage 80, max_rows_fetched 50;
--- WMS operation complete.
NS%
For the syntax, see the “ALTER WMS Command” (page 106). Also see “How to Execute WMS
Commands in NCI” (page 25).
Displaying the WMS System Configuration
The INFO WMS command displays the threshold values that are in effect for the WMS system
configuration:
SQL>mode ns
NS%info wms;
MAX_CPU_BUSY MAX_MEM_USAGE MAX_ROWS_FETCHED EXEC_TIMEOUT WAIT_TIMEOUT HOLD_TIMEOUT STATS_INTERVAL RULE_INTERVAL
------------ ------------- ---------------- ------------ ------------ ------------ -------------- -------------
100 85 0 0 0 0 5 60
--- WMS operation complete.
For the syntax, see the “INFO WMS Command” (page 123). Also see “How to Execute WMS
Commands in NCI” (page 25).
Configuring User-Defined Services
This section describes how to establish user-defined services for managing query workloads in
WMS. For more information about services, see “What Are Services?” (page 27). The examples
show WMS commands that are executed in a Neoview Command Interface (NCI) session. For
more information, see “How to Execute WMS Commands in NCI” (page 25).
To add, alter, delete, or display information about a service, see:
• “Adding a Service” (page 29)
• “Altering a Service” (page 35)
• “Deleting a Service” (page 36)
• “Displaying Information About the Service Definitions” (page 36)
• “Displaying the Service in Effect” (page 37)
For information about holding and releasing services, see “Managing Services” (page 76).
Adding a Service
Use the ADD SERVICE command to add a service to the WMS configuration on a Neoview
platform and set the service's priority level and thresholds. For example, this ADD SERVICE
command defines a service named SERVICE1:
ADD SERVICE service1
PRIORITY HIGH,
MAX_CPU_BUSY 95,
MAX_MEM_USAGE 80,
ACTIVE 08:00 TO 24:00,
EXEC_TIMEOUT 120,
WAIT_TIMEOUT 720,
HOLD_TIMEOUT 1440,
PLAN, TEXT,
COMMENT "Created by DBA on 5/14/2009";
SERVICE1 has a high priority, system resource thresholds of 95% and 80%, an active period of
8:00 a.m. to midnight, and timeout values for executing, waiting, and holding queries. Both the
SQL query plan and text are stored for each query that is associated with SERVICE1.
Here are some things to consider when defining services:
Configuring User-Defined Services 29