You can use SAPDBA for Informix to perform an emergency logical-log backup when the logical log is full. For more information, see Emergency Logical-Log Backup with SAPDBA (Informix 6.0).

• SAPDBA is installed correctly. Refer to SAPDBA Setup.
• You are logged on in expert mode, that is, as user informix , and you have started SAPDBA. Refer to Starting SAPDBA.
• You are using Informix version 6.0.
• You are using the Informix tool ON-Archive for data recovery.

1. Check that the script arcpanic (used in the emergency backup process) is in the directory /usr/sap/<SID>/sys/exe/run . For more information, see "Copying Scripts" in Preparing SAP Scripts for ON-Archive.
2. Check that $INFORMIXDIR/bin is in the path for user informix .
3. Define the tape device for emergency logical-log backup. To do this, edit the ON-Archive configuration file – normally called config.arc and found in directory $INFORMIXDIR/etc – as user informix . Refer to Editing the config.arc File for ON-Archive. Make an entry like the following (the script arcpanic expects the name DATARTR_VOP ):

DEVICE DATARTR_VOP = /dev/rmt/0hc

For more information, see Defining Devices for ON-Archive with SAP Scripts.

After editing the file, you need to restart the ON-Archive cataloger for the changes to take effect, as follows:

stop_oncatlgr (it does not matter if the cataloger was not running)

start_oncatlgr

4. Define the volume set for emergency logical-log backup, by entering the following at the command line:

$ onarchive 'DEFINE/VSET=ONDATARTRLOG/DEVICE_TYPE=DATARTR_VOP/DRIVER=TAPE/ACCESSIBILITY=0/CLASS=SYSTEM'

5. Define the tape volume for emergency logical-log backup, by entering the following at the command line:

For more information, see Setting Up Volume Sets and Volumes for ON-Archive with SAP Scripts.

You are now ready to perform an emergency logical-log backup with SAPDBA.