Tapefile-to-volume table, Applicable access keys tapefile-to-volume table – HP NonStop G-Series User Manual
Page 141
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 TFTOVV10.
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
VALID and INVALID.
VOLUMECATALOG (VARCHAR(30))
The volume catalog that owns the tape volumes used
for the tape file.
POOLNAME (VARCHAR(30))
The pool containing the tapes.
VOLSETID (VARCHAR(6))
The volume serial of the first tape volume in the
volume set.
COMMENT (VARCHAR(80))
The comment string given to the file ID in the
TAPECATALOG DEFINE.
Clustering key columns for the
TapeFile
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 the tape file.
VOLSER (VARCHAR(6))
The volume serial of the tape volume containing the
tape 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.
Valid values start at 1.