Neoview Workload Management Services Guide (R2.4)

• “Using Default Threshold Values in a Service” (page 30)
• “Setting the Priority of the Service” (page 31)
• “Setting the System Resource Thresholds of the Service” (page 31)
• “Setting the Active Time of the Service” (page 32)
• “Setting Query Timeouts for the Service” (page 33)
• “Setting the Maximum Rows to Retrieve” (page 33)
• “Setting the Output Options of the Service” (page 34)
• “Adding a Comment for the Service” (page 34)
For the syntax, see the “ADD SERVICE Command” (page 91).
IMPORTANT: After adding services to the WMS configuration, you should create connection
rules for those services. If you do not define connection rules and associate them with your
services, WMS does not assign queries to those services but instead assigns queries to the default
service, HP_DEFAULT_SERVICE. To add connection rules and associate them with services,
see “Connection Rules” (page 40).
Using Default Threshold Values in a Service
For each service that you add, you can set thresholds. If you do not set a threshold in the ADD
SERVICE command, WMS copies the default threshold value from the WMS system configuration
and stores it in the service definition. For example, suppose that you use this ADD SERVICE
command in NCI to add a service, D1, that does not set any threshold values:
SQL>mode ns
NS%add service d1;
--- WMS operation complete.
NS%
The WMS system configuration has these threshold values when you add the D1 service:
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.
NS%
As this example shows, the D1 service inherits the threshold values of the WMS system
configuration:
NS%status service d1;
SERVICE_NAME STATE
SERVICE_PRIORITY MAX_CPU_BUSY MAX_MEM_USAGE MAX_ROWS_FETCHED ACTIVE_TIME SQL_PLAN SQL_TEXT EXEC_TIMEOUT
WAIT_TIMEOUT HOLD_TIMEOUT
------------------------------------------------------------------------------------------------ ---------
---------------- ------------ ------------- -------------------- ------------------- -------- -------- ------------
------------ ------------
D1 ACTIVE
MEDIUM 100 85 0 FROM 00:00 TO 24:00 NO_PLAN NO_TEXT
0 0 0
--- WMS operation complete.
NS%
Altering the WMS system configuration after you add a service does not alter the threshold
values of the service. The service retains the threshold values that existed at the time you added
the service until you alter the threshold values of the service by using the ALTER SERVICE
command. For more information, see “Altering a Service” (page 35).
30 Configuring Services