For more information, see Recovery Report with SAPDBA.

• 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 an Informix version later than 6.0. If you are using version 6.0, see Preparing for Recovery Reports (Informix 6.0).
• You are using the Informix tool ON-Archive for data recovery. The recovery reports are not available if you are using ontape or ON-Bar .

1. Copy the scripts archive_control , backup_control , and logevent.sh from the CD SAP-Kernel into the directory that SAPDBA can use, as described in Preparing SAP Scripts for ON-Archive. If you have not performed these preparations, then proceed as follows:
1. Mount the CD SAP-Kernel.
2. Log in as user <sid>adm :

su - <sid>adm

3. Change to the target directory, $INFORMIXDIR/etc :

cd $INFORMIXDIR/etc

4. Copy the scripts from CD, for example, archive_control :

cp /sapcd/DBTOOLS/archive_control archive_control

The access rights on this file must allow users to execute it.

2. Make sure that the parameter ALARMPROGRAM in the ONCONFIG file is correctly set. Refer to Editing the ONCONFIG File for ON-Archive.
3. Define the entry for the archive.log file in the config.arc file. See parameter ACTIVITYLOG in Editing the config.arc File for ON-Archive.
4. Make sure that the directory $INFORMIXDIR/sapreorg/recover.rpt exists with write access for all users. You should have completed this step as part of installing SAPDBA. Refer to Setting Up SAPDBA Working Directories.

SAPDBA now automatically creates the recovery report after every archive and logical-log backup with ON-Archive . To make sure that the report is being created, or if you need to perform a restore in the event of database failure involving data loss, see Listing Recovery Report with SAPDBA.