Determining the Volume Required (ON-Archive) 

Use

When creating an archive of your Informix database with ON-Archive , you need to mount the correct volume. This procedure tells you how to identify the correct volume.

Procedure

To determine the volume from the archive volume set that must be mounted on the device used for archives with ON-Archive , perform the following command:

$ onarchive 'LIST/VOLUME=*/VSET=DBTAP'

Result

The display looks similar to the following ( sset = save set , psset = physical saveset , L. = Label , Max = Maximum space , Used = Used space):

Vol No

Nb sset

Nb psset

Volume L.

Prot

Max

Used

F

0001

1

1

0001

RWD

0

3401364

Y

0002

1

1

0002

RWD

0

1078986

Y

0003

1

1

0003

RWD

0

0

N

0004

1

1

0004

RWD

0

0

N

Total of 4 volume(s)

The display shows that the first volume that is not full is volume 3 (it has a value of N for "No" in the right-hand column, under the heading F for "Full?"). This volume is used next and you should mount it on the tape drive for archives. Mount the volume in advance if you are using unattended operation. It is also the volume that you are prompted for if you do the archive interactively.

 

See also:

Informix documentation