File catalog tables and structures, Tapefileconfig table, Applicable access key – HP NonStop G-Series User Manual

Page 139

Advertising
background image

Database Design of DSM/TC

DSM/Tape Catalog User’s Guide — 520233-008

9 - 5

File Catalog Tables and Structures

licensed) copy of the SQLCI2 object file. For these procedures, see the SQL/MP
Installation and Management Guide
.

This procedure works only for relocation within one system, not to a second
system.

DSM/TC logical tape catalog names are preserved. You cannot use the procedure
to alter the logical names.

The relocation procedure cannot be used to separate a combined
VOLCAT/FILECAT subvolume into separate physical subvolumes, nor can it be
used to combine separate VOLCAT and FILECAT subvolumes into a combined
VOLCAT/FILECAT.

File Catalog Tables and Structures

The file catalog consists of these SQL/MP tables:

TapefileConfig Table

One TapefileConfig record exists for each tape file name present in the file catalog.
The record contains the highest absolute generation number assigned for the file ID.
When a new generation of a file ID is requested, the absolute generation number is
incremented, and the resulting value is stored in the tape file name entry.

The name of the table is CONFIG. The name of the shorthand view is CONFGV10.

The TapefileConfig record comprises these fields:

Applicable Access Key

SQL/MP Table

Page

TapefileConfig Table

9-5

Tapefile Table

9-6

Tapefile-to-Volume Table

9-7

Diskfile Table

9-8

Diskfile-to-Volume Table

9-10

FILEID (VARCHAR(60))

The dataset ID assigned by the user.

LASTGENERATION (INTEGER)

The absolute generation number archived for the file ID.
The valid values start at 1.

The primary key for the

CONFIG

definition record is:

FILEID

Advertising
This manual is related to the following products: