beautypg.com

Diskfile table, Applicable access keys diskfile table – HP NonStop G-Series User Manual

Page 142

background image

Database Design of DSM/TC

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

9 - 8

Diskfile Table

Applicable Access Keys

Diskfile Table

A Diskfile record represents a disk file written to tape by the standard BACKUP
program. One record is created for each disk file. Disk files are retrieved by their fully

VERSION (SMALLINT)

The version number of the tape file generation. Valid
values start at 0.

PHYSICALCOPY (SMALLINT)

The physical copy number of this tape volume. This
is used to distinguish between a BACKUP and a
BACKCOPY of a tape file. Valid values start at 1.

LOGICALCOPY (SMALLINT)

The logical copy number of this tape volume. This is
used to distinguish parallel BACKUP and
BACKCOPY tape files. Valid values are 1 and 2.

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.

FILESECTION (SMALLINT)

Specifies the volume number relative to the first
volume of a multivolume file ID; for example, the
second volume of a file ID that spans three volumes.
Valid values start at 1.

FILESEQUENCE (SMALLINT)

Specifies the relative position of the file ID in a tape
volume set containing multiple file IDs; for example,
the eighth file ID of a tape volume set. Valid values
start at 1.

FILESEQLABELLBA (LARGEINT)

Logical Block Address of the tape file’s label on
volume.

Primary key columns for the

TapeFile-To-Volume

record are:

VOLUMECATALOG

VOLSER

POOLNAME

FILEID

GENERATION

VERSION

Index TapeFile-To-Volume 1 record is:

FILEID

GENERATION

VERSION

PHYSICALCOPY

LOGICALCOPY

This manual is related to the following products: