DSM/Tape Catalog User's Guide

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 d
istinguish 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 d
istinguish 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
vo
lume set.
VOLINDEX (SMALLINT) The position number of the volume in the tape
vo
lume 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
vo
lume 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
vo
lume 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
vo
lume.
Primary key columns for the Tap
eFile-To-Volume record are: VOLUMECATALOG
VOLSER
POOLNAME
FILEID
GENERATION
VERSION
Index TapeFile-To-Volume 1 record is: FILEID
GENERATION
VERSION
PHYSICALCOPY
LOGICALCOPY