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.