RECOVERY_TIME option

Function

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

Allowed values

Integer, in minutes

Scope

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

Default

2

Description

This option is used 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.

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