RECOVERYRETRYLIMIT

Specifies the maximum number of retry attempts after a DBMS recoverable failure (deadlock, timeout or resource unavailable) has prevented an operation from completing successfully.

If RECOVERYRETRYLIMIT=0, then no attempt is made after encountering a recoverable failure. If all retry attempts are unsuccessful, the recoverable failure is escalated to a nonrecoverable failure and handled according to the ENDONERROR keyword setting.

Note: For deadlocks, there is no time delay between consecutive retries. In other words, the value of the TIMEOUTRECOVERYDELAY keyword is not considered. Recovery from deadlocks is more likely when retries are performed consecutively without delay.

This keyword is optional.

Default Setting—10 attempts

Minimum Setting—0 attempts

Maximum Setting—65535 attempts