Neoview Workload Management Services Guide (R2.4)

PLAN, TEXT,
COMMENT "Created by DBA on 5/14/2009";
ADD SERVICE service4
PRIORITY HIGH,
MAX_CPU_BUSY 95,
MAX_MEM_USAGE 80,
ACTIVE 00:00 TO 7:59,
EXEC_TIMEOUT 120,
WAIT_TIMEOUT 720,
HOLD_TIMEOUT 1440,
PLAN, TEXT,
COMMENT "Created by DBA on 5/14/2009";
Setting Query Timeouts for the Service
You can set these timeout values for a service:
• EXEC_TIMEOUT, a value from zero to 1440 minutes, which causes WMS to cancel executing
queries associated with the service when the timeout value is reached.
• WAIT_TIMEOUT, a value from zero to 1440 minutes, which causes WMS to reject waiting
queries associated with the service when the timeout value is reached.
• HOLD_TIMEOUT, a value from zero to 1440 minutes, which causes WMS to reject or cancel
holding queries associated with the service when the timeout value is reached.
For example, this ADD SERVICE command defines a service that has timeout values for executing
(two hours), waiting (12 hours), and holding (24 hours):
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";
This ADD SERVICE command defines a service that has timeout values for executing (four hours)
and waiting (24 hours) queries but not for holding queries, which keeps queries in the holding
state indefinitely:
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";
If you do not specify a timeout value, the default is zero, meaning that no timeout is in effect.
CAUTION: Do not set an EXEC_TIMEOUT value for a service that handles long-running
INSERT-SELECT statements because, WMS cancels the INSERT-SELECT statement when the
timeout value is reached, causing the entire transaction to be rolled back.
Setting the Maximum Rows to Retrieve
Specify MAX_ROWS_FETCHED to set the maximum number of rows that each query in the
service can return. You can specify a value from zero (meaning no limit) to 9223372036854775807.
The default is zero, which means there is no limit on the number of rows that each query can
return.
Configuring User-Defined Services 33