SPOOL_TIMEOUT[6]

Enables greater control over record-lock retries by setting timeout and interval durations.

Syntax:

SPOOL_TIMEOUT=timeout:interval

Parameters:

timeout
The amount of time in milliseconds to continue to retry the lock before ceasing the attempt.
interval
The amount of time in milliseconds before initiating a new lock retry attempt.

Properties:

Default: SPOOL_TIMEOUT=500:100

Comments:

Set this environment variable to resolve reported record-locked messages, which, depending on hardware performance, can occur especially during shutdown of an enterprise server instance with an SSTM job.