DELAYEDRECOVERY

Determines whether Analytic Services delays free space recovery after an application crashes or terminates abnormally.

This setting does not apply to aggregate storage databases.

Syntax

DELAYEDRECOVERY [appname] TRUE | FALSE

appname Optional. The name of an application to which this setting should apply. If omitted, all applications are affected.
TRUE Analytic Services delays freespace recovery.
FALSE Analytic Services does not delay freespace recovery.

Description

This setting controls whether Analytic Services delays freespace recovery.

Database recovery takes place any time you load an application that has just crashed or terminated abnormally. Essbase does not perform free space recovery automatically because it is the most expensive part of database recovery. You must either trigger freespace recovery explicitly or change the default setting so that Essbase will recover free space automatically.

Example

DELAYEDRECOVERY TRUE
Analytic Services delays freespace recovery.

See Also

alter database <DBS-NAME> recover freespace, which is the statement you use to explicitly recover freespace.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com