Sets the maximum length of time (in minutes) for recovery from system failure.

Syntax

{ dbsrv11 | dbeng11 } -gr minutes ...

Applies to

All operating systems and database servers.

Remarks

When a database server is running with multiple databases, the recovery time that is specified by the first database started is used unless overridden by this option.

The value specified by the -gr option instructs the database server how often to perform a checkpoint. For example, if you set -gr to 5, then the database sever tries to perform checkpoints often enough so that recovery takes no longer than 5 minutes. However, if recovery is necessary, it runs to completion, even if it takes longer than the length of time specified by -gr. The default value is the setting of the recovery_time database option, which defaults to 2 minutes.

The recovery time includes both the estimated recovery time and the estimated checkpoint time for the database.

See also

• recovery_time option [database]
• How the database server decides when to checkpoint