To make it easier with ON-Archive to use your Informix database archives and logical-log backups for restore, you can have a recovery report automatically produced during normal database operation. You can then view the report using SAPDBA. The report lists the archive and logical-log backup volumes required to restore your database to the state it was in at a given point in time, thus allowing you to use your archives and backups as quickly as possible. After every archive and every backup, the system creates the report.

This report is only available if you use ON-Archive for data recovery (you cannot produce it with ontape ).

For more information, including how to set up the report so it is created after every database archive and logical-log backup, see Recovery Report with SAPDBA.