DSM/Tape Catalog User's Guide

Database Design of DSM/TC
DSM/Tape Catalog User’s Guide — 520233-008
9 - 13
Volume-to-FileCatalog Table
Applicable Access Keys
Volume-to-FileCatalog Table
The Volume-to-FileCatalog table is used to identify which file catalog contains the tape
file information for a particular tape volume set. This lets the system determine which
tape files are contained on each assigned tape volume. All tape files on a volume set
are cataloged in a single file catalog.
The name of the table is VTOFC. The name of the shorthand view is VTOFCV20.
The Volume-to-FileCatalog record comprises these fields:
Applicable Access Key
OWNERID (VARCHAR(47)) Contains the ten word PHANDLE of the process using
or trying to use the tape. It might contain non printable
characters. Otherwise, it is null.
DENSITY (VARCHAR(4)) The density at which tape volumes in the pool are
writte
n. Valid values are 1600 and 6250. NULL is used
for cartridge tapes.
ENDOFDATALBA (LARGEINT) The Logical Block Address of the n
ext available tape
location, if it is an assigned labeled backup tape in an
appendable pool. For a full backup tape in an
appendable pool, the value is 2
31
-1. This is used for
USE OUT APPEND tape positioning. Otherwise, the
value is -1.
Primary key columns for the Vol
ume record are: VOLSER
POOLNAME
Index VolI1 OWNERID
Index VolI2 VOLSETID
Index VolI3 VOLUMESTATUS
VOLSETID (VARCHAR(6)) The volume serial number of the first tape volume in the
t
ape volume set
POOLNAME (VARCHAR(30)) The pool containing the tape volume
FILECATALOG (VARCHAR(30)) The file catalog where the tape file ID and related
information
are stored
TAPEFORMAT (SMALLINT) The tape format assigned on the tape volume set.
Primary key columns for the Vol
ume-To-FileCatalog record are: VOLSETID
POOLNAME