DSM/Tape Catalog User's Guide

Database Design of DSM/TC
DSM/Tape Catalog User’s Guide 520233-008
9 - 9
Diskfile Table
qualified file names and the time they are written to tape. Because disk files are also
contained in a tape file, the file ID and GEN fields can be used to access a disk file
record. All disk files written to tape in a single invocation of the BACKUP program are
cataloged in the same file catalog.
The name of the table is DISKFILE. The name of the shorthand view is DFV10.
The Diskfile record comprises these fields:
DISKFILENAME (VARCHAR(35)) The fully qualified physical disk file name, whether
local or remote.
TIMEDUMPED (DATETIME) The time when the BACKUP process started.
PHYSICALCOPY (SMALLINT) The physical copy number of this disk file.
This
distinguishes a BACKUP and a BACKCOPY of a disk
file. Valid values start at 1. BACKCOPY is a standard
Backup Restore utility.
LOGICALCOPY (SMALLINT) The logical copy number of this disk file. This
dif
ferentiates between parallel BACKUP and parallel
BACKCOPY disk files. Valid values are 1 and 2.
FILEID (VARCHAR(60)) The name of the tape file assigned by the user.
GENERATION (INTEGER) The absolute generation number of the tape file
cont
aining this disk file. Valid values start at 1.
VERSION (SMALLINT) The version number of the file ID generation. Valid
value
s start at 0.
DISKFILESTATUS (CHAR(2)) The current status of the disk file record. Valid values
fo
r the current status are VALID and INVALID (VA
and IN, respectively).
OPENED (CHAR(1)) Open flag (Y if it was open; N if it was not open).
BROKEN (CHAR(1)) Broken flag (Y if broken; N if not broken).
RFNEEDED (CHAR(1)) Roll forward flag (Y if ROLLFORWARD was needed;
N if ROLLF
ORWARD was not needed).
CORRUPT (CHAR(1)) Corrupt flag (Y if it was corrupt; N if it was not
corrupt).
AUDITED (CHAR(1)) Audited flag (Y if it was audited; N if it was not
au
dited).
FILECODE (SMALLINT) The file code of the disk file. Valid values start at 0.