Transaction Retries

transaction retries n

n specifies the number of attempts to be made at retrying an implicit transaction that has failed because of deadlock. A setting of -1 causes the transaction to be retried until deadlock does not occur. This option applies only when the application has SET AUTORETRY set ON.

Valid Settings

-1 to 1000

Windows

10

UNIX

10

Related Information

SET AUTORETRY