Content Comparison

Column Name

System Column Name

Data Type

Description

VOLUME_SERIAL

VOLSERIAL

VARCHAR(6)

The volume serial which BRMS uses to identify the volume.

VOLUME_IDENTIFIER

VOLUME_ID

VARCHAR(32)

The volume identifier associated with an optical volume.  VOLUME_IDENTIFIER will be the same as VOLUME_SERIAL for tape volumes. 

VOLUME_STATUS

STATUS

VARCHAR(10)

Indicates the current state of the volume.              

The possible values are:

• ACTIVE                The volume is active.

• DOWNLOAD       The volume is being moved from a cloud location. 

• ERROR                The volume was flagged in error.

• EXPIRED             The volume is expired.

• INITIALIZE          The volume requires initialization before it can be used.

• UPLOAD              The volume is being moved to a cloud location.               

CARTRIDGE_TYPE

TYPE

VARCHAR(10)

Nullable

The cartridge type is reflected.  

The possible values are:

• media-type - The type is retrieved from the device capability system information.  See the device documentation for more information.                 

• VT - The volume is a virtual volume.  The image catalog identifies if it is tape or optical.

Contains the null value if type has not been set.

OWNING_SYSTEM

SYSTEM

VARCHAR(17)

Nullable

The name of the system which owns the volume in a BRMS network.

Contains the null value if the owning system has not been set.

MEDIA_CLASS

MEDIACLASS

VARCHAR(10)

The name of the media class assigned to the media volume.

DUPLICATION_STATUS

DUPESTATUS

VARCHAR(9)

Nullable

The duplication status of the volume.

The possible values are:

• BOTH                  The media had been duplicated and it is also marked for duplication.

• DUPLICATE        The media has been duplicated.

• MARKED            The media is marked for duplication.

Contains the null value when no duplication status is set.

CONTAINER

CONTAINER

VARCHAR(10)

Nullable

The container name assigned to the media volume.

Contains the null value when the volume does not have a contain name.

CREATED

CREATED

DATE

The date represents the most recent occurrence of the following:

• First time data was written to the volume

• Volume was initialized

• Volume was added to the BRMS inventory

EXPIRATION

EXPIRATION

VARCHAR(8)

Nullable

When the volume expires.

The possible values are:

• PERM                                 The volume was assigned permanent retention status.

• VERSIONS                          The volume is using version expiration. 

Contains the null value when the EXPIRATION_DATE column has a specific date.

EXPIRATION_DATE

EXPIREDATE

DATE

Nullable

When the volume expires.

The possible values are:

• expiration-date                The date that the volume expires. 

Contains the null value when the EXPIRATION column is PERM or VERSIONS.

CURRENT_LOCATION

LOCATION

VARCHAR(10)

The name of the current storage location of the volume.

MOVE_POLICY

MOVEPOLICY

VARCHAR(10)

Nullable

The name of the move policy the volume is using.

Contains the null value when no move policy is being used.

SCHEDULED_MOVE

MOVE

DATE

Nullable

The date of the next move operation.

Contains the null value when the volume is not scheduled to move.

IMAGE_CATALOG

CATALOG

VARCHAR(10)

Nullable

The name of the image catalog where the media is created.

Contains the null value if the CARTRIDGE_TYPE is not VT.

MEDIA_TIMES_USED 

USED

INTEGER

The number of times the volume has been written over at the beginning of the tape.

READ_ERRORS 

R_ERRORS

BIGINT

The number of read errors for the media.

WRITE_ERRORS 

W_ERRORS

BIGINT

The number of write errors for the media.

VOLUME_FULL

FULL

VARCHAR(3)

Indicates whether the BRMS has marked the volume as full so it can no longer be append to. 

The possible values are:

• NO                The volume is not full in BRMS.

• YES                The volume is full in BRMS.

SERIAL_SET

SERIAL

VARCHAR(3)

Indicates whether the volume is part of a serial set.

The possible values are:

• NO                The volume did not span multiple volumes.

• YES                The volume was used by a serial backup which spanned multiple volumes.

PARALLEL_SET

PARALLEL

VARCHAR(3)

Indicates whether the volume is part of a parallel set.

The possible values are:

• NO                The volume was not used for a parallel backup.

• YES                The volume was used by a parallel backup which used multiple volumes.

VOLUME_RESERVED

RESERVED

VARCHAR(6)

Nullable

Shows the job number which reserved the volume for usage.  When a volume is reserved, it cannot be used by any other jobs.

Contains the null value if the volume is not being used by any other jobs.

FILE_GROUP

FILE_GROUP

VARCHAR(10)

Nullable

The file group assigned to the volume.  For control group backups this column will be the control group name.

Contains the null value when the file group name is not assigned.

FILE_GROUP_TYPE

GROUP_TYPE

VARCHAR(10)

Nullable

The file group type assigned to the volume.

The possible values are:

• ARCHIVE       The file group name was used by an archive process.

• BACKUP        The file group name was used by a backup process.

Contains the null value when the file group type is not assigned.