Start of Content Area

Procedure documentation Setting Up Volume Sets and Volumes for ON-Archive Without SAP Scripts  Locate the document in its SAP Library structure

Prerequisites

This procedure describes how to manually define volume sets and volumes for ON-Archive with the Informix database if you are not using the SAP scripts. SAP recommends that you use the names for volume sets and volumes given in this procedure, but you might have particular requirements at your site for different names.

You should have already entered your device names in the config.arc file. For more information, see Defining Devices for ON-Archive Without SAP Scripts.

Follow this procedure before you start performing database archives, logical-log backups, and restores of your database. You define volume sets and volumes manually in ON-Archive . Refer to Entering ON-Archive Commands Manually and the Informix documentation.

Procedure

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

    2. su - informix
  2. Enter the following at the command line to start ON-Archive :

    3. $ onarchive

    You see the ON-Archive command prompt as follows:

    Onarchive>

    Note

    The volume sets and volumes in the following steps use the device names given in Defining Devices for ON-Archive Without SAP Scripts.

  3. Enter volume set(s) for database archive at the ON-Archive command prompt:

    4. Volume set(s) to enter

    Purpose

    Comment

    DEFINE/VSET=DBTAP/
    DEVICE_TYPE=DBTAP_VOP/DRIVER=TAPE/
    ACCESSIBILITY=0/
    CLASS=SYSTEM

    Sequential database archive, using single logical device DBTAP_VOP .

    Note that the logical device DBTAP_VOP can be linked to several physical devices (that is, tape drives).

    DEFINE/VSET=DBTAP0/
    DEVICE_TYPE=DBTAP0_VOP/DRIVER=TAPE/
    ACCESSIBILITY=0/
    CLASS=SYSTEM

    DEFINE/VSET=DBTAP3/
    DEVICE_TYPE=DBTAP3_VOP/DRIVER=TAPE/
    ACCESSIBILITY=0/
    CLASS=SYSTEM

    DEFINE/VSET=DBTAP5/
    DEVICE_TYPE=DBTAP5_VOP/DRIVER=TAPE/
    ACCESSIBILITY=0/
    CLASS=SYSTEM

    Parallel database archive, using multiple logical devices.

    Parallel database archives are useful for large databases or to reduce the time taken.

    You need to set up dbspace sets for parallel database archives. For more information on setting up dbspace sets, see the Informix documentation.

    You also need to set up multiple logical and physical devices.

  4. Enter volume set(s) for logical-log backup to tape or disk at the ON-Archive command prompt:

    5. Volume set(s) to enter

    Purpose

    Comment

    DEFINE/VSET=LOGTAP/
    DEVICE_TYPE=LOGTAP_VOP/DRIVER=TAPE/
    ACCESSIBILITY=0/
    CLASS=SYSTEM

    Tape backup of logical log or copy to tape, using single logical device LOGTAP_VOP .

    Note that the logical device LOGTAP_VOP can be linked to several physical devices.

    DEFINE/VSET=LOGDIR/
    DEVICE_TYPE=LOGDIR_VOP/DRIVER=DISK/
    ACCESSIBILITY=0/
    CLASS=SYSTEM

    Disk backup of logical log, using single logical device LOGDIR_VOP .

    You should also define a tape volume set (see previous entry), because you need to copy the backed-up logs from disk due to space constraints.

  5. Enter a volume set for emergency logical-log backup to disk:
    6.

    DEFINE/VSET=ONDATARTRLOG/DEVICE_TYPE=LOGPANIC/DRIVER=DISK

    This command sets up a disk volume set, using a single logical device, LOGPANIC . This volume set is used when the logical log has filled up and the database has stopped processing. Refer to Emergency Logical-Log Backup without SAP Scripts (ON-Archive). For a summary of measures to avoid emergency logical-log backups, see Preventing Emergency Logical-Log Backup.

    Now you can start setting up the volumes for the above volume sets. For more information about the number of tape volumes that you require, see Volume Sets and Volumes for ON-Archive.

  6. For tape volume sets, enter a command like the following at the ON-Archive command prompt:

    7. DEFINE/VOLUME/VSET=DBTAP

    This command creates a volume in the volume set DBTAP . ON-Archive assigns volume numbers sequentially, starting with 1. SAP recommends that you stick a label on your tape volumes showing at least the volume set name and volume label.

    Repeat this step until you have created all the tape volumes you need in each of your tape volume sets.

  7. For disk volume sets, enter a command like the following at the ON-Archive command prompt:

DEFINE/VOLUME/VSET=ONDATARTRLOG/MAX_SPACE=99999999/VIRTUAL=(/infbackup/logpanic/V1)

This command creates a volume in sub-directory V1 of volume set ONDATARTRLOG . The name V1 is optional. However, you should use it in case you need to add additional volumes later, because the volumes are then in the same directory and can be easily managed.

These volumes should at least be large enough to hold the entire logical log. Therefore, MAX_SPACE is set very high in the above example.

Repeat this step for your other disk volume sets.

Result

Look in the archive.log file to see the results of this procedure. You can see entries for each volume set, similar to the following:

Apr 13 1995 13:20:03 #00000000# <21434> onarchive (informix) Defined DBTAP: DEFINE/VSET=DBTAP/DEVICE_TYPE=DBTP1_VOP/DRIVER=TAPE/
ACCESSIBILITY=10/CLASS=USER/USER=(root, informix, arcadm)

You can see entries for each volume, similar to the following:

Apr 13 1995 13:22:37 #00000000# <21444> onarchive (informix) Defined DBTAP:0001: DEFINE/VOLUME/VSET=DBTAP/LABEL=DBT1

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

 

See also:

Volume Sets and Volumes for ON-Archive

Setting Up Volume Sets and Volumes for ON-Archive with SAP Scripts

Informix documentation