Diskfile table, Applicable access keys diskfile table – HP NonStop G-Series User Manual
Page 142
![background image](/manuals/396697/142/background.png)
Database Design of DSM/TC
DSM/Tape Catalog User’s Guide — 520233-008
9 - 8
Diskfile Table
Applicable Access Keys
Diskfile Table
A Diskfile record represents a disk file written to tape by the standard BACKUP
program. One record is created for each disk file. Disk files are retrieved by their fully
VERSION (SMALLINT)
The version number of the tape file generation. Valid
values start at 0.
PHYSICALCOPY (SMALLINT)
The physical copy number of this tape volume. This
is used to distinguish between a BACKUP and a
BACKCOPY of a tape file. Valid values start at 1.
LOGICALCOPY (SMALLINT)
The logical copy number of this tape volume. This is
used to distinguish parallel BACKUP and
BACKCOPY tape files. Valid values are 1 and 2.
VOLSETID (VARCHAR(6))
The volume serial of the first tape volume in the
volume set.
VOLINDEX (SMALLINT)
The position number of the volume in the tape
volume set; for example, the fourth volume in the
volume set. Valid values start at 1.
FILESECTION (SMALLINT)
Specifies the volume number relative to the first
volume of a multivolume file ID; for example, the
second volume of a file ID that spans three volumes.
Valid values start at 1.
FILESEQUENCE (SMALLINT)
Specifies the relative position of the file ID in a tape
volume set containing multiple file IDs; for example,
the eighth file ID of a tape volume set. Valid values
start at 1.
FILESEQLABELLBA (LARGEINT)
Logical Block Address of the tape file’s label on
volume.
Primary key columns for the
TapeFile-To-Volume
record are:
VOLUMECATALOG
VOLSER
POOLNAME
FILEID
GENERATION
VERSION
Index TapeFile-To-Volume 1 record is:
FILEID
GENERATION
VERSION
PHYSICALCOPY
LOGICALCOPY