Creating the Recovery Report with SAPDBA (Informix (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Creating the Recovery Report with SAPDBA (Informix 6.0)

Use

You can use SAPDBA for Informix version 6.0 to create a recovery report to help you restore your database. You must create the report before the restore is necessary, that is, during normal database operation. For more information, see Creation of Recovery Report with SAPDBA (Informix 6.0).

Prerequisites

SAPDBA is installed correctly. Refer to SAPDBA Setup.

You know how to use SAPDBA and have logged on. Refer to Starting SAPDBA.

You are using the Informix tool ON-Archive for data recovery. The recovery reports are not available if you are using ontape .

You are using Informix version 6.0. If you have a later Informix version, refer to Recovery Report with SAPDBA.

You have prepared for the recovery report.

Procedure

Choose Create Recovery Report in SAPDBA for Informix 6.0.

If an archive or backup is running at the time, SAPDBA first lets it finish. A message confirms that the recovery report is being created.

Note

You must create the recovery report after every archive and logical-log backup to make sure that, if the database fails and you have to perform a restore, you have the most up-to-date recovery report available.

Result

You now have a recovery report that you can use in the event of database failure to help you restore the database more quickly and easily. You can now view the report.

You must perform regular housekeeping to clear up the directory containing the reports. Refer to SAPDBA Housekeeping.