DSM/Tape Catalog User's Guide

Database Design of DSM/TC
DSM/Tape Catalog User’s Guide — 520233-008
9 - 7
Tapefile-to-Volume Table
Applicable Access Keys
Tapefile-to-Volume Table
The Tapefile-to-Volume table identifies which tape volumes contain a tape file. One
record is created for each tape volume a tape file spans. These records let DSM/TC
determine exactly which tape volumes contain a given tape file.
The name of the table is TFTOV. The name of the shorthand view is TFT
OVV10.
The Tapefile-to-Volume record comprises these fields:
CATALOGFILES (CHAR(1)) The BACKUP catalog level used.

Y means that CATALOGFILES was specified,
which indicates that individual disk files are
cataloged.

N means that only the aggregate tape file is
cataloged. Not used if TapeFileMode is USER.
This field has a value of N for Backup and Restore
2.0 BACKUP
operations.
TAPEFILESTATUS (VARCHAR(7)) The current status of the tape file. Valid values are
V
ALID and INVALID.
VOLUMECATALOG (VARCHAR(30)) The volume catalog that owns the tape volumes used
for th
e tape file.
POOLNAME (VARCHAR(30)) The pool containing the tapes.
VOLSETID (VARCHAR(6)) The volume serial of the first tape volume in the
vo
lume set.
COMMENT (VARCHAR(80)) The comment string given to the file ID in the
T
APECATALOG DEFINE.
Clustering key columns for the TapeFil
e record are: FILEID
GENERATION
VOLSETID
Index Tape File1 VOLSETID
Index Tape File 2 EXPIRATIONDATE
VOLUMECATALOG (VARCHAR(30)) The volume catalog that owns the tape volumes used
for th
e tape file.
VOLSER (VARCHAR(6)) The volume serial of the tape volume containing the
t
ape file.
POOLNAME (VARCHAR(30)) The pool containing the tape volume.
FILEID (VARCHAR(60)) The name of the tape file assigned by the user.
GENERATION (INTEGER) The absolute generation number of the tape file.
V
alid values start at 1.