DSM/Tape Catalog User's Guide

Database Design of DSM/TC
DSM/Tape Catalog User’s Guide — 520233-008
9 - 11
Volume Catalog Tables and Structures
Applicable Access Keys
Volume Catalog Tables and Structures
The volume catalog consists of these SQL tables:
Pool Table
The Pool table for each media pool maintains one record, containing the name of the
media pool, the constraints placed on tapes contained in the media pool, and the name
of the last scratch tape allocated from the pool. By tracking scratch tapes, DSM/TC
ensures that tape volumes in the pool are used evenly. This prevents repeated use of
the tape volumes at the front of the media pool while not using those at the back of the
media pool.
The name of the table is POOL. The name of the shorthand view is POOL
V20.
The Pool record comprises these fields:
VOLUMECATALOG (VARCHAR(30)) The volume catalog containing the pool.
POOLNAME (VARCHAR(30)) The pool containing the tape volume.
VOLSETID (VARCHAR(6)) The volume serial of the first tape volume in the
volume se
t.
VOLINDEX (SMALLINT) The position number of the volume in the tape
volume se
t; for example, the fourth volume in the
volume set. Valid values start at 1.
FILEPOSITIONLBA (LARGEINT) Reserved for future use. Value is -1.
Clustering key columns for the DiskFil
e-To-Volume record are: DISKFILENAME
VOLSETID
Index Diskfile to Volume 1 VOLSETID
SQL/MP Table Page
Pool Table 9-11
Volume Table 9-12
Volume-to-FileCatalog Table 9-13
POOLNAME (VARCHAR(30)) The name of the pool containing tapes assigned by
the user.
LABEL (VARCHAR(8)) The allowable label types that are allowed in the
poo
l. Valid values are ANY, ANSI, IBM, and BACKUP.
DENSITY (VARCHAR(4)) The density of tape at which tape volumes in the pool
are
written. Valid values are ANY, 1600, and 6250.
TYPE (VARCHAR(10)) The physical tape of tape volume. Valid values are
CAR
T3480, CART5120, OPEN, CARTDAT, or ANY.