Database file recovery options table

 

The table outlines the recovery options for database files.

RECOVER parameter specified
Access path/ Maintenance	*NO	*AFTIPL	*IPL
Keyed sequence access path/ immediate or delayed maintenance	No database recovery at IPL File available immediately Access path rebuilt first time file opened	Access path rebuilt after IPL	Access path rebuilt during IPL
Keyed sequence access path rebuild maintenance	No database recovery at IPL File available immediately Access path rebuilt first time file opened	Not applicable; no recovery is done for rebuild maintenance	Not applicable; no recovery is done for rebuild maintenance
Arrival sequence access path	No database recovery at IPL File available immediately	Not applicable; no recovery is done for an arrival sequence access path	Not applicable; no recovery is done for an arrival sequence access path

 

Parent topic:

Database recovery process after an abnormal system end