Start of Content Area

Procedure documentation Editing the config.arc File for ON-Archive  Locate the document in its SAP Library structure

Use

This procedure describes how to configure the config.arc file, one of a number of files required for ON-Archive with the Informix database. The default ON-Archive configuration file is called config.arc . This file contains essential information required by ON-Archive to correctly perform data recovery (that is, archive, backup, and restore). To see how the config.arc file relates to the other files required by ON-Archive , see Configuration Files for ON-Archive.

Follow this procedure before you start performing archives, backups, and restores of your database.

Note

The default configuration file for ON-Archive is the config.arc file, located in the $INFORMIXDIR/etc directory. However, your installation might use a different name for the configuration file. To find the name of the ON-Archive configuration file, check the ARC_CONFIG environment variable.

Procedure

  1. Log on as user informix using the following command:

    2. su - informix
  2. Open the config.arc file, which you can normally find in the $INFORMIXDIR/etc directory.
  3. Set the parameter PRIVILEGE as follows, making sure that any other privilege entry is disabled:

    4. PRIVILEGE = OPERATOR, GROUP
  4. Set the parameter ACTIVITYLOG as follows to determine the log file for ON-Archive events:

    5. ACTIVITYLOG = /informix/<SID>/etc/archive.log

    In this documentation, we assume you have specified archive.log as the ON-Archive log file.

  5. Set the parameter DEVICE to specify logical names for your hardware devices. A device is a logical group of physical hardware devices. For example, the logical device LOGTAP_VOP might refer to one or more physical devices /dev/rmt/0hc , /dev/rmt/1hc and so on.

    6. The logical device name is on the left-hand side of the device entry, the physical device name on the right-hand side. In the example below, LOGTAP_VOP is the logical device name and /dev/rmt/0m is the physical device name:

    DEVICE LOGTAP_VOP = /dev/rmt/0m

    You must define devices before you can define volume sets and volumes for ON-Archive . How you define devices depends on whether you are using the SAP scripts. Refer to one of the following:

    - Defining Devices for ON-Archive with SAP Scripts

    - Defining Devices for ON-Archive Without SAP Scripts

    Caution

    If you specify the same physical device for backup and archive, you run the risk that the logical log fills up during an archive because no tape drive is available to back it up. At this point, the database stops processing and an emergency backup of logical-log files might be required. Therefore, SAP recommends you to have different physical devices for archive and backup.

  6. When you have finished editing config.arc , you need to restart the ON-Archive cataloger for the changes to take effect. Enter the following from the command line regardless of whether the cataloger was running first:

$ stop_oncatlgr

$ start_oncatlgr

Result

You have now completed one of the steps required to configure ON-Archive for performing archives, backups, and restores of your database.

 

See also:

Configuration of ON-Archive

Editing the ONCONFIG File for ON-Archive

Editing the oper_deflt.arc File for ON-Archive

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