level of recovery

The level of recovery that is possible depends on the backup plan you created as well as the database's current state. Any state other than "Available" indicates that you must either wait for an operation to complete or take some recovery action, as indicated below.

Available

The database is available for use.

Backup Pending

You must do a full backup of the database before accessing it. This state occurs after either LOGRETAIN has been enabled (or set to RECOVERY) and accepted, or USEREXIT has been enabled and accepted.

Restore Pending

The database must be restored from a backup image. The restore must complete before you can access the database.

Roll Forward Enabled

The database is enabled for roll-forward recovery.

Roll Forward Pending

The database must be rolled forward from the contents of the database log files. The roll-forward must complete before you can access the database.

Table Space Roll Forward Pending

This state indicates that the changes to a single table space must be rolled forward from the contents of the database log files. The roll-forward must complete before you can access the table space.

Unknown

This state indicates that a connection cannot be established to the database. The connection may be faulty, or the database may not be started.

Inconsistent

A transaction is pending or some other task is pending on the database and the data is not consistent at this point. If the system "crashes" while the database is not consistent, you will need to restart the database to make it usable. If this does not work you will need to restore the database from a backup image.