Neoview Workload Management Services Guide (R2.5)

SERVICE2 has a medium priority, allows a maximum CPU busy of 100 percent and memory
usage of 85 percent, and has an active period of 8:00 a.m. to midnight. It has timeout values
for executing queries (four hours) and waiting queries (24 hours) but not holding queries.
• This command adds a service, SERVICE3, to the WMS configuration:
ADD SERVICE SERVICE3
PRIORITY LOW,
MAX_CPU_BUSY 85,
MAX_MEM_USAGE 60,
ACTIVE 12:00 TO 24:00,
MAX_ROWS_FETCHED 2000,
COMMENT "Created by DBA on 5/14/2010";
SERVICE3 has a low priority, allows a maximum CPU busy of 85 percent and memory usage
of 60 percent, and has an active period of noon to midnight. It limits the number of rows
fetched from the query to 2000 rows.
188 WMS Commands