Neoview Workload Management Services Guide (R2.5)

Description or ActionFieldGroup Box
Maximum time interval a query can be in the waiting state before the
query automatically times out. By default, this value is 0, meaning
no timeout. This timeout specifies the default value to use when the
timeout is not set for the WMS service.
Enter a value from 0 to 1440 minutes. Zero means no timeout.
Wait Timeout (minutes)
Maximum time interval a query can be in the holding state before the
query automatically times out. By default, this value is 0, meaning
no timeout. This timeout specifies the default value to use when the
timeout is not set for the WMS service.
Enter a value from 0 to 1440 minutes. Zero means no timeout.
Hold Timeout (minutes)
Applying the Default Threshold Values to a Service
If you do not set a threshold when adding a service, 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 wms
WMS>add service d1;
--- WMS operation complete.
WMS>
The WMS system configuration has these threshold values when you add the D1 service:
WMS>info wms;
MAX_CPU_BUSY MAX_MEM_USAGE MAX_ROWS_FETCHED EXEC_TIMEOUT WAIT_TIMEOUT HOLD_TIMEOUT STATS_INTERVAL ...
------------ ------------- ---------------- ------------ ------------ ------------ -------------- ...
100 85 0 0 0 0 5 ...
--- WMS operation complete.
WMS>
As this example shows, the D1 service inherits the threshold values of the WMS system
configuration:
WMS>status service d1;
SERVICE_NAME ... MAX_CPU_BUSY MAX_MEM_USAGE MAX_ROWS_FETCHED ... EXEC_TIMEOUT WAIT_TIMEOUT HOLD_TIMEOUT ...
-------------- ... ------------ ------------- ----------------- ... ------------ ------------ ------------ ...
D1 ... 100 85 0 ... 0 0 0 ...
--- WMS operation complete.
WMS>
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. For more information, see “Alter
a Service” (page 61) or the “ALTER SERVICE Command” (page 199).
Configure the WMS System 53