RECOVERY_TIME option

Function

Sets the maximum length of time, in minutes, that the database server takes to recover from system failure.

Allowed values

Integer, in minutes

Default

2

Scope

Can be set only for the PUBLIC group. Takes effect when the server is restarted.

Description

Use this option with the CHECKPOINT_TIME option to decide when checkpoints should be done.

A heuristic measures the recovery time based on the operations since the last checkpoint. Thus, the recovery time is not exact.

See also

Chapter 10, “Transactions and Versioning” in the Sybase IQ System Administration Guide.