Start of Content Area

Procedure documentation Setting Up Storage Devices for Logical-Log Backup (ON-Archive)  Locate the document in its SAP Library structure

Use

You need to set up enough storage devices – that is, tape drives – with adequate capacity for backing up the logical log of your Informix database.

Recommendation

If you can, it is best to have enough tape drives, volume sets, and volumes to mount a volume from each volume set on a separate tape drive and back up the logical log in unattended mode without allowing the logical log to fill completely.

Procedure

  1. Decide the number of tape drives.

    2. You need at least one tape drive for logical-log backup. To reduce the chances of a tape volume overflowing, you can define additional physical devices for the logical device assigned to backup.

    SAP recommends that you have one or more tape drives dedicated solely to logical-log backup. This is essential if you are using continuous logical-log backup to tape.

  2. Decide whether to perform logical-log backup in unattended mode.

    3. Define logical storage devices with the suffix _VOP if you wish to use these in unattended mode (that is, using onautovop ). By inserting the appropriate tape volumes in the assigned devices, you can allow the backup to proceed without operator attention. This applies to continuous or automatic logical-log backup.

  3. Consider the speed of your tape drives.

Your drives must be fast enough to cope with the maximum rate at which the logical log fills. Local devices are more likely to cope than remote devices.

For more information about setup of storage devices, see Editing the File config.arc for ON-Archive.

 

See also:

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