Start of Content Area

Procedure documentation Entering ON-Archive Commands Manually  Locate the document in its SAP Library structure

Use

Although SAP recommends that you use the SAP scripts and the DBA Planning Calendar – which means you do not need to enter ON-Archive commands manually – this section is provided in case you decide not to use these tools with your Informix database.

Prerequisites

Read the Informix documentation carefully because ON-Archive is a complex tool.

Procedure

  1. Choose one of the following ways to interact with ON-Archive :

Method of interaction

How to interact

From the operating system command line

Enter your command, for example:

$ onarchive 'archive/dbspaceset=*/level=0/vset=dbtap'

From the ON-Archive command line
  1. Enter the following from the operating system command line:
    2.

    $ onarchive

    Then you see the ON-Archive command-line prompt:

    Onarchive>
  2. Enter your command, for example:

Onarchive> archive/dbspaceset=*/level=0
/vset=dbtap

Using the menu interface

You can access the menu interface

  • From the operating system command line:

$ onarchive menu
  • From the ON-Archive command-line:

Onarchive> menu

  1. Define the action.

    2. To define an archive or backup you have to create a request. The system enters the request in the ON-Archive catalog with a unique identification number.

  2. Execute the action.

    3. After creating the request, you have to explicitly execute it. You can execute a request immediately, or you can leave it in the catalog to be executed at a later time. You can also use onautovop (the virtual operator) to start the command in unattended mode.

  3. If you want, combine the "define action" and "execute action" steps into a single step by entering the parameter immediate on the operating system command line, for example:

$ onarchive 'archive/dbspaceset=*/level=0/vset=dbtap/immediate'

You can also enter immediate on the onarchive command line, for example:

Onarchive> archive/dbspaceset=*/level=0/vset=dbtap/immediate

You can also define immediate as a default in the oper_deflt.arc file. This documentation uses this convention. If you use the /immediate qualifier as a default or enter it on the command line as part of an ON-Archive command, the command is executed immediately. Refer to Editing the File oper_deflt.arc for ON-Archive.

You can use the same approach with the qualifier /autovop to execute the command in unattended mode. You can enter it either as a default (not recommended) or on the command line when required.

Note

The following Informix programs are used with ON-Archive :

Program

Purpose

onarchive

Works interactively with ON-Archive (as long as the database is available)

ondatartr

Performs off-line functions (for example, to restore a database that is down)

onautovop

Performs unattended operations

oncatlgr

Communicates between ON-Archive and the database

 

See also:

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