Start of Content Area

Procedure documentation Setting Parameters for Logical-Log Backup (ON-Bar)  Locate the document in its SAP Library structure

Use

This procedure tells you how to set parameters in the ONCONFIG file for logical-log backup on your Informix database using ON-Bar .

Prerequisites

You have decided on your approach to logical-log backup, including whether to use continuous or manual logical-log backup.

Procedure

  1. To check whether the settings in your ONCONFIG file are correct, you can view the file in SAPDBA. See Listing System Information with SAPDBA.
  2. Log on as user informix .
  3. Open the ONCONFIG file, which you can normally find in the $INFORMIXDIR/etc (UNIX) or %INFORMIXDIR%\etc (NT) directory.

    4. Note

    SAP recommends you to use the IECC with Windows NT. This affects the parameters to be set in the next step.

  4. Set the following parameters in the ONCONFIG file:

ALARMPROGRAM = $INFORMIXDIR/etc/log_full.sh (UNIX)

If you use the Informix Enterprise Command Center (IECC), set the following:

LOG_BACKUP_MODE = CONT (UNIX and NT)

The database server runs the program log_full.sh to continuously check the logical log. When a logical-log file fills, an event alarm is triggered and the file is backed up. You must make sure that storage media is always available for the logical-log backup. You must also reserve a dedicated storage device for the logical-log backup.

ALARMPROGRAM = $INFORMIXDIR/etc/no_log.sh (UNIX)

If you use the Informix Enterprise Command Center (IECC), set the following:

LOG_BACKUP_MODE = MANUAL (UNIX and NT)

If the ALARMPROGRAM or LOG_BACKUP_MODE parameters are not specified, you have to perform manual logical-log backup.
  1. Restart the database server for the changes in the ONCONFIG file to take effect.

Result

If you set parameters for continuous logical-log backup, when the database server starts, continuous logical-log backup also starts. For more information, see Performing a Continuous Logical-Log Backup (ON-Bar).

If you set parameters for manual logical-log backup, be sure to perform the manual logical-log backup when required. For more information, see Performing a Manual Logical-Log Backup (ON-Bar).

 

See also:

Informix documentation at http://www.informix.com