Start of Content Area

Procedure documentation Checking Archive Result with Activity Log (ON-Archive)  Locate the document in its SAP Library structure

Use

You can check the results of an Informix database archive with ON-Archive by looking in the ON-Archive activity log. The ON-Archive activity log is normally called archive.log and is stored in the directory /informix/<SID>/etc . For more information, see the ACTIVITYLOG parameter in Editing the config.arc File for ON-Archive.

Two examples of archive results are given below. The first example is for a normal sequential archive and the second example for a parallel archive.

Procedure

Sequential Archive

The result of a normal sequential archive of all dbspaces should look similar to the following:

Apr 07 1995 11:27:25 #00000000# <11495> onarchive (arcadm) Created request #00000005#: ARCHIVE/APART/DBSPACESET=*/LEVEL=0/VSET=DBTAP
Apr 07 1995 11:27:32 #00000005# <11500> onautovop (arcadm) Begin archive to DBTAP

12:53:59 #00000005# <11500> Processing rootdbs to DBTAP:0001

12:54:00 #00000005# <11500> Processing logdbs to DBTAP:0001

12:54:00 #00000005# <11500> Processing psapsource to DBTAP:0001

12:54:01 #00000005# <11500> Processing physdbs to DBTAP:0001

12:54:01 #00000005# <11500> Processing psappool to DBTAP:0001

12:54:01 #00000005# <11500> Processing psapdocu to DBTAP:0001

12:54:02 #00000005# <11500> Processing psapuser1 to DBTAP:0001

12:54:02 #00000005# <11500> Processing psapprot to DBTAP:0001

12:54:02 #00000005# <11500> Processing psapstab to DBTAP:0001

12:54:03 #00000005# <11500> Processing psapbtab to DBTAP:0001

12:54:03 #00000005# <11500> Processing psapclu to DBTAP:0001

12:54:03 #00000005# <11500> Processing psapload to DBTAP:0001

12:54:04 #00000005# <11500> Processing psapddic to DBTAP:0001

Apr 07 1995 12:55:03 #00000005# <11500> onautovop (arcadm) End archive: SUCCESS

Parallel Archive

The following display demonstrates the result of a parallel archive. The archive is split into two parts, DBTAP and DBTAP2 . You can see the request numbers 1 and 3 to define the two archive requests to DBTAP and DBTAP2 respectively, under the virtual operator onautovop (the output has been reformatted slightly so it is easier to read).

First, you see the archive requests:

Apr 06 1995 16:59:05 #00000000# <10484> onarchive (arcadm) Created request #00000001#:

ARCHIVE/APART/DBSPACESET=SET000072A/LEVEL=0/VSET=DBTAP
Apr 06 1995 16:59:09 #00000000# <10493> onarchive (arcadm) Created request #00000003#:

ARCHIVE/APART/DBSPACESET=SET000072B/LEVEL=0/VSET=DBTAP2

Then you see the archive running:

Apr 06 1995 16:59:11 #00000001# <10489> onautovop (arcadm) Begin archive to DBTAP

Apr 06 1995 16:59:14 #00000003# <10498> onautovop (arcadm) Begin archive to DBTAP2

18:40:03 #00000003# <10498> Processing logdbs to DBTAP2:0001

18:40:04 #00000003# <10498> Processing physdbs to DBTAP2:0001

18:40:04 #00000003# <10498> Processing psapdocu to DBTAP2:0001

18:40:04 #00000003# <10498> Processing psapuser1 to DBTAP2:0001

18:40:05 #00000003# <10498> Processing psapstab to DBTAP2:0001

18:40:05 #00000003# <10498> Processing psapbtab to DBTAP2:0001

18:40:05 #00000003# <10498> Processing psapddic to DBTAP2:0001

Apr 06 1995 18:41:07 #00000003# <10498> onautovop (arcadm) End archive: SUCCESS

18:47:09 #00000001# <10489> Processing rootdbs to DBTAP:0001

18:47:09 #00000001# <10489> Processing psapsource to DBTAP:0001

18:47:09 #00000001# <10489> Processing psappool to DBTAP:0001

18:47:09 #00000001# <10489> Processing psapprot to DBTAP:0001

18:47:09 #00000001# <10489> Processing psapclu to DBTAP:0001

18:47:10 #00000001# <10489> Processing psapload to DBTAP:0001

Apr 06 1995 18:48:13 #00000001# <10489> onautovop (arcadm) End archive: SUCCESS

Caution

You must always do a logical-log backup directly after a parallel archive. Refer to Logical-Log Backup.

 

See also:

Checking Archive Status (ON-Archive)

Checking Result of Database Backup or Archive with Message Log

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