Determines whether Essbase delays free space recovery after an application crashes or terminates abnormally.
This setting does not apply to aggregate storage databases.
DELAYEDRECOVERY [appname] TRUE | FALSE
appname—Optional. The name of an application to which this setting should apply. If omitted, all applications are affected.
TRUE—Essbase delays freespace recovery
FALSE—Essbase does not delay freespace recovery.
This setting controls whether Essbase 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.
DELAYEDRECOVERY TRUE
Essbase delays freespace recovery.
Alter Database<DBS-NAME> recover freespace, which is the statement you use to explicitly recover freespace.