DSM/Tape Catalog User's Guide

Database Design of DSM/TC
DSM/Tape Catalog User’s Guide — 520233-008
9 - 10
Diskfile-to-Volume Table
Applicable Access Keys
Diskfile-to-Volume Table
The Diskfile-to-Volume table identifies which tape volumes contain a disk file. One
record is generated for each tape volume a disk file spans.
The name of the table is DFTOV. The name of the shortha
nd view is DFTOVV10.
The Diskfile-to-Volume record comprises these fields:
FILETYPE (CHAR(2)) Which type of disk file. Valid values are:

EN for an ENSCRIBE file

IN for a SQL/MP index

PG for a SQL/MP program

PV for a SQL/MP protection view

SV for a SQL/MP shorthand view

TA for a SQL table
DISKFILEEOF (INTEGER) The size of the disk file in bytes. Valid values start at
0.
If the EOF cannot be represented as a 32-bit
signed integer, the column contains 2
32
-1.
LASTMODTIME (DATETIME) The time when the disk file wa
s last modified. This
value is retrieved from the disk file label.
VOLSETID (VARCHAR(6)) The volume serial of the first tape volume in the
volume set.
POOLNAME (VARCHAR(30)) The pool containing the tape volume.
VOLUMECATALOG (VARCHAR(30)) The volume catalog containing the pool.
DISKFILEEOF64 (LARGEINT) The size of the disk file in bytes. Valid values start at
0.
Clustering Key DISKFILENAME
FILEID
GENERATION
VOLSETID
Index Diskfile1 FILEID
Index Diskfile 2 VOLSETID
DISKFILENAME (VARCHAR(35)) The fully qualified physical disk file name, whether
lo
cal or remote.
TIMEDUMPED (DATETIME) The time when the BACKUP process started.
VOLSER (VARCHAR(6)) The volume serial of the tape volume on which the
di
sk was written.