DSM/Tape Catalog User's Guide

Database Design of DSM/TC
DSM/Tape Catalog User’s Guide — 520233-008
9 - 12
Volume Table
Applicable Access Key
Volume Table
One record is maintained in the Volume table for each tape volume. This record
contains the tape volume name, its type (open reel, cartridge, and so on), whether it is
scratch or assigned, and the pool to which it belongs.
The name of the table is VOLUME. The name of the shorthand view is VOLV20.
The Volume record comprises these fields:
AUTOSCRATCH (CHAR(1)) The status of tape after expiration:

Y means the tape volume becomes scratch.

N means the tape volume becomes released.
SEARCHSPACE (VARCHAR(8)) Indicates whether or not the pool is in the system
search
space. Valid values are IN (for included) or EX
(for excluded).
LASTSCRATCHVOL (VARCHAR(6)) Determines the last scratch tape volume suggested
by DS
M/TC for use, or reflects the last ASSIGNED
volume used for APPEND.
CANAPPEND (CHAR(1)) Can append to tapes in this pool, Y or N.
Primary key for the Pool record
is: PoolName
VOLSER (VARCHAR(6)) The name of the tape volume assigned by the user.
POOLNAME (VARCHAR(30)) The pool containing the tape volume.
LABEL (VARCHAR(8)) The label type of the tape volume. Valid values are
ANSI, IBM, and BACKUP
.
TYPE (VARCHAR(10)) The physical type of tape volume. Valid values are
CAR
T5120, CART3480, CARTDAT, and OPEN.
VOLUMESTATUS (VARCHAR(8)) The status of the tape volume. Valid values are
ASSIGNED, BAD, FULL, INUSE, RE
LEASED,
SCRATCH, and SELECTED.
VOLSETID (VARCHAR(6)) The volume serial of the first tape volume in the volume
set. This field is n
ull if the tape volume is not part of a
tape volume set.
VOLINDEX (SMALLINT) The position number of the volume in the tape volume
set; for e
xample, the fourth volume in the volume set.
Valid values start at 1. This field is null if the tape
volume is not part of a tape volume set.