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.