DSM/Tape Catalog User's Guide

Database Design of DSM/TC
DSM/Tape Catalog User’s Guide — 520233-008
9 - 6
Tapefile Table
Tapefile Table
A Tapefile record represents a single generation of a file ID. Each tape file record is
identified by file ID, generation, version, and copy numbers. One tape file record is
created for each tape file, whether generated by an application or by the BACKUP
program. A tape file is always named by a file ID.
The name of the table is TAPEFILE. The name of the shorthand view is TFV10.
The Tapefile record comprises these fields:
FILEID (VARCHAR(60)) The name of the tape file assigned by the user.
GENERATION (INTEGER) The absolute generation number of the file ID. Valid
va
lues start at 1.
VERSION (SMALLINT) The version number of the generation of the file ID.
V
alid values start at 0.
PHYSICALCOPY (SMALLINT) The physical copy number of this tape file. This is
used to d
istinguish between a BACKUP and a
BACKCOPY of a tape file. Valid values start at 1.
BACKCOPY is a standard Backup Restore utility.
LOGICALCOPY (SMALLINT) The logical copy number of this tape file. This is used
to d
istinguish parallel BACKUP and BACKCOPY
tape files. Valid values are 1 and 2.
CREATIONDATE (DATETIME) The time the tape file was created in the file catalog.
EXPIRATIONDATE (DATE) The date the tape file record expires and will be
ma
rked invalid.
RECORDFORMAT (CHAR(2)) The record format of the file ID. Valid values are
FIXED and UNDEFINED (
FI and UN, respectively).
RECORDLENGTH (INTEGER) The record length of the file ID. Valid values are 0
throu
gh 56k.
BLOCKLENGTH (INTEGER) The block length of the file ID. Valid values are 0
throu
gh 52.
TAPEFILEMODE (CHAR(4)) The application type that wrote the tape file. Valid
va
lues are:

BKVO (for a volume mode backup)

BKFI (for a file mode backup)

BIFI (for IBMBACKUP in file mode)

BIVO (for IBMBACKUP with VOLUMEMODE
specified)

USER (for user applications)