Performing Emergency Logical-Log Backup with SAPDB (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Performing Emergency Logical-Log Backup with SAPDBA (Informix 6.0)

Use

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 uses the SAP script arcpanic to perform the logical-log backup.

If you are not using the SAP scripts and your logical log is full, refer to Emergency Logical-Log Backup without SAP Scripts (ON-Archive).

You must perform an emergency logical-log backup when a message like the following appears in the system message log file:

16:44:49 Logical Log Files are Full - Backup is Needed

The database stops processing and you must back up the logical log to let processing continue.

Prerequisites

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.

You have prepared for emergency logical-log backup with SAPDBA and have the required tapes ready.

Procedure

Choose Emergency Backup in SAPDBA.

You see a dialog box confirming that you wish to start the emergency backup.

Choose yes.

SAPDBA executes the SAP script arcpanic to perform the emergency logical-log backup. For more information, see Performing Emergency Logical-Log Backup Using SAP Scripts (ON-Archive).

Result

The logical log is no longer full, allowing the database to continue processing and writing transactions.

Note

After the emergency backup has successfully completed, create a full (that is, level-0) archive in case you have problems using the data just backed up. SAP advises this although it should not strictly be necessary if the emergency backup was successful. Refer to Creation of an Archive (ON-Archive).

To make sure you do not need to perform another emergency backup because the logical log is full, we strongly recommend that you review your logical log backup approach. Refer to Approach to Logical-Log Backup (ON-Archive).

See also:

Informix documentation