Start of Content Area

Procedure documentation Setting Up Unattended Archive (ON-Archive)  Locate the document in its SAP Library structure

Use

If you want to perform unattended archives of your Informix database with ON-Archive , you have to use the APART qualifier in the oper_dflt.arc file. When you use this qualifier, only one save set is written per volume.

Note

Do not set the APART qualifier as a default in the oper_dflt.arc file. This could interfere with your logical-log backups by writing only one save set for a logical-log backup to a single volume, effectively preventing continuous backup (although SAP recommends that you do not normally use continuous backup). For more information on setting the APART qualifier, see Editing the File oper_deflt.arc for ON-Archive.

Recommendation

SAP recommends you to perform unattended archive with the DBA Planning Calendar in the Computing Center Management System (CCMS) of the SAP System.

Procedure

How you set up unattended archive depends on how you run your archives:

The APART qualifier is used automatically when you schedule your archives using the DBA Planning Calendar in the Computing Center Management System (CCMS) of the SAP System. You need take no further action.

For more information, see Scheduling Backups and Archives with CCMS (ON-Bar and ON-Archive).

The following is an example with the APART qualifier:

$ onarchive 'ARCHIVE/DBSPACESET=SET1/VSET=DBTAP/APART'

You should use the APART qualifier for unattended archives and start the archive with a fresh volume. Using a fresh volume reduces the chance that a volume fills before the archive is completed. If a volume fills during an unattended archive and you have not defined additional physical tape devices in the logical device for the volume set used in the archive, then the archive fails.

For more information, see Entering ON-Archive Commands Manually.

 

See also:

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