QUSRBRM.MEDIA_INFO View

The media info view contains information about a BRMS media object.

The values returned for the columns in this view are similar to the values returned by the Work with Media using BRM (WRKMEDBRM) command.

Authorization:  

The authorization ID of the statement must include the following privileges:

  • *OBJOPR and *READ authority to the QUSRBRM/MEDIA_INFO object.

The system name is MEDIA_INFO. The schema is QUSRBRM.

Result Table

The following Table describes the columns in the view:

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

Column Name changed to SCHEDULED_MOVE with PTFs 7.3 SI78289, 7.4 SI78290, 7.5 SI28291.  Earlier PTF level will show the Column Name as 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.

TEXT

New field with PTFs 7.3 SI78289, 7.4 SI78290, 7.5 SI28291. 

TEXT

VARCHAR(50)

The text that describes the volume.

Examples

Example 1- Report volumes marked as full:

SELECT VOLSERIAL, STATUS, EXPIRATION, EXPIREDATE, LOCATION, MEDIACLASS FROM QUSRBRM.MEDIA_INFO WHERE FULL = 'YES'

Example output:

VOLUME_SERIAL

VOLUME_STATUS 

EXPIRATION_DATE

EXPIRATION

LOCATION

MEDIA_CLASS

000016

ACTIVE

1201231

-

TAPMLB01

ULTRIUM3

000026

ACTIVE

-

PERM

VAULT 

SYSBACKUP

000040

ACTIVE

-

PERM

VAULT

SYSBACKUP

000041

ACTIVE

1200901

-

TAPMLB02

ULTRIUM3

000043

ACTIVE

1200901

-

TAPMLB02

ULTRIUM3

Example 2 - Report expired volumes from SYS_A or SYS_B for any ULTRIUM2 or ULTRIUM3 media classes:

SELECT VOLSERIAL, STATUS, SYSTEM, LOCATION, MEDIACLASS FROM QUSRBRM.MEDIA_INFO WHERE STATUS = 'EXPIRED' AND (SYSTEM = 'APPN.SYSA' OR SYSTEM = 'APPN.SYSB') AND (MEDIACLASS = 'ULTRIUM2' OR MEDIACLASS = 'ULTRIUM3')

Example output:

VOLUME_SERIAL

VOLUME_STATUS

OWNING_SYSTEM

LOCATION

MEDIA_CLASS

000077

EXPIRED

APPN.SYSA

TAPMLB01

ULTRIUM3

000105

EXPIRED

APPN.SYSA

VAULT 

ULTRIUM2

000106

EXPIRED

APPN.SYSB

VAULT

ULTRIUM2

000140

EXPIRED

APPN.SYSB

TAPMLB02

ULTRIUM3

000417

EXPIRED

APPN.SYSB

TAPMLB02

ULTRIUM3

Example 3 - Report volumes in use and currently reserved for a BRMS operation:

SELECT VOLSERIAL, RESERVED, SYSTEM FROM QUSRBRM.MEDIA_INFO WHERE RESERVED <> ' '

Example output:

VOLUME_SERIAL

RESERVED

OWNING_SYSTEM

000075

447679

APPN.SYSA

000102

447679

APPN.SYSA

000122

447583

APPN.SYSB

000160

447583

APPN.SYSB

000425

447583

APPN.SYSB

Example 4 - Report volumes that are active and marked for duplication:

SELECT VOLSERIAL, DUPESTATUS, SYSTEM FROM QUSRBRM.MEDIA_INFO WHERE STATUS = 'ACTIVE' AND (DUPESTATUS = 'MARKED' OR DUPESTATUS = 'BOTH')

Example output:

VOLUME_SERIAL

DUPLICATION_STATUS

OWNING_SYSTEM

000072

MARKED

APPN.SYSA

000115

MARKED

APPN.SYSA

000145

BOTH

APPN.SYSB

000400

MARKED

APPN.SYSB

001425

BOTH

APPN.SYSB

Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.