Volume catalog tables and structures, Pool table, Applicable access keys – HP NonStop G-Series User Manual
Page 145
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 POOLV20.
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 set.
VOLINDEX (SMALLINT)
The position number of the volume in the tape
volume set; 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
DiskFile-To-Volume
record are:
DISKFILENAME
VOLSETID
Index Diskfile to Volume 1
VOLSETID
SQL/MP Table
Page
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
pool. 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
CART3480, CART5120, OPEN, CARTDAT, or ANY.