Determining the Volume Required (ON-Archive)
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 you must mount 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 at
http://www.informix.com