SET AUTORETRY

Specifies if implicit transactions are to be retried automatically if a deadlock or a time-out occurs.

Syntax

SET AUTORETRY ON|OFF

Comments

The AUTORETRY option is set OFF by default.

When AUTORETRY is ON, implicit transactions that fail because of deadlock or time-outs will be retried until they finally succeed or an internal maximum number of retries is reached (which can be set by the database configuration option "transaction retries").

If these implicit transactions fail, then an error message is printed.

 

WARNING!

When running ZIM commands from the command prompt, there is no way to auto retry transactions even if this option is set to ON. Therefore, in this case, all deadlock conditions are IGNORED!