Previous Topic: RUNUNITS Statement ParametersNext Topic: SQL CACHE Statement—Controls SQL Caching


Example: RUNUNITS Statements

Predefining Run Units

The following statement creates five predefined run units for load area processing in the TSTDICT dictionary. The run units will be terminated if they remain inactive for more than eight minutes.

ADD RUNUNITS FOR LOADER
    DICTNAME IS TSTDICT
    COUNT IS 5
    IDLE INTERVAL IS 8.

Changing the Idle Interval

The following statement changes the idle interval for the predefined run units for the TSTDICT dictionary:

MODIFY RUNUNITS FOR LOADER
    DICTNAME IS TSTDICT
    IDLE INTERVAL IS 5.

Deleting Predefined Run Units

The following statement deletes the predefined run units for the TSTDICT dictionary:

DELETE RUNUNITS FOR LOADER
    DICTNAME IS TSTDICT.

For more information about predefined run units, see System Run Units.