Neoview Workload Management Services Guide (R2.4)

Setting the Priority of the Service
You can set the priority of the service relative to other services. Choose one of these priorities,
from highest to lowest:
• PRIORITY URGENT
• PRIORITY HIGH
• PRIORITY MEDIUM-HIGH
• PRIORITY MEDIUM
• PRIORITY LOW-MEDIUM
• PRIORITY LOW
For example, these ADD SERVICE commands define services that have high, medium, and low
priorities:
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";
ADD SERVICE service2
PRIORITY MEDIUM,
MAX_CPU_BUSY 75,
MAX_MEM_USAGE 60,
EXEC_TIMEOUT 240,
WAIT_TIMEOUT 1400,
PLAN, TEXT,
COMMENT "Created by DBA on 5/14/2009";
ADD SERVICE service3
PRIORITY LOW,
MAX_CPU_BUSY 55,
MAX_MEM_USAGE 40,
MAX_ROWS_FETCHED 2000,
PLAN, TEXT,
COMMENT "Created by DBA on 5/14/2009";
If you do not specify a priority for the service, the default priority is medium.
Setting the System Resource Thresholds of the Service
You can set these system resource thresholds for the service:
• MAX_CPU_BUSY, which is 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 of the Neoview
platform.
• MAX_MEM_USAGE, which is a percentage from zero to 100 of memory usage allowed for
the service. This value is an average of memory usage across all segments of the Neoview
platform.
For example, these ADD SERVICE commands define services that have different system resource
thresholds for high, medium, and low priorities:
ADD SERVICE service1
PRIORITY HIGH,
MAX_CPU_BUSY 95,
MAX_MEM_USAGE 80,
ACTIVE 08:00 TO 24:00,
EXEC_TIMEOUT 120,
Configuring User-Defined Services 31