You need to copy and edit the SAP scripts to prepare them for use with ON-Archive and the Informix database. Only use this procedure if you are working on a UNIX platform, because ON-Archive does not run on NT platforms.

First, you copy the scripts, then you edit the script logevent.sh .

1. Mount the CD INFORMIX RDBMS .
2. Log on as user <sid>adm using the following command:

su - <sid>adm

3. Change to the target directory ( /usr/sap/<SID>/SYS/exe/run ) using the following command:

cdexe

4. Copy the file arcprep from CD with the following command, replacing <CD-Mountdir> with the actual name of your mount directory:

cp /<CD-Mountdir>/DBTOOLS/ARCPREP arcprep

5. Repeat the previous step for the other scripts ( arcvolum , arcauto , arcpanic , archive_control , backup_control , and logevent.sh ).

To prepare the script logevent.sh for logical-log backup, you need to edit it as follows:

1. Mount the CD INFORMIX RDBMS .
2. Log in as user informix , using the following command:

su - informix

3. To prepare the script logevent.sh , set the following values in the script:

– MAX_PCT=50

Set this value to the required percentage full for the logical log to trigger a logical-log backup. SAP recommends 50% full as the default.

– BACKUP_VSET=LOGTAP

Set this value to the target volume set for the logical-log backup, normally LOGTAP .

4. To activate the script logevent.sh , you must set the ALARMPROGRAM parameter in the ONCONFIG file. Make sure that the name and the directory for the parameter are correct. Refer to Editing the File ONCONFIG for ON-Archive.
5. Stop and restart the SAP System and the Informix server for the changes to take effect.

Defining Devices for ON-Archive with SAP Scripts

Setting Up Volume Sets and Volumes for ON-Archive with SAP Scripts

Preparing for Recovery Reports with SAPDBA