QUSRBRM.MEDIA_SET_INFO Table Function

The Media_Set_Info table function returns serial media set information.  Serial media sets are single or multiple volumes that were created together during a save operation.

Parameters

QUSRBRM.MEDIA_SET_INFO (VOLUME => volume-serial)

volume-serial

Specifies the volume serial which BRMS uses to identify the volume.  The volume serial is a maximum of 6 characters in length.

Authorization: 

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

  • *USE authority to QUSRBRM.MEDIA_SET service program.

The schema is QUSRBRM.

Result Table

The result of the function is a table containing a row for each volume in the set with the format shown in the following table:

Column Name

Data Type

Description

VOLUME_SERIAL

VARCHAR(6)

The volume serial which BRMS uses to identify the volume.

VOLUME_IDENTIFIER

VARCHAR(32)

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

SEQUENCE

INTEGER

The volume sequence number in the set.

VOLUME_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.             

MEDIA_CLASS

VARCHAR(10)

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

EXPIRATION

VARCHAR(8)

Nullable

When the volume expires.

The possible values are:

  • PERM                     The was assigned permanent retention status.

  • VERSIONS             The volume is using versioning expiration.

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

EXPIRATION_DATE

DATE

Nullable

When the volume expires.

The possible values are:

  • expiration-date    The specific date that the volume expires.

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

LOCATION

VARCHAR(10)

The name of the current storage location of the volume.

MOVE

DATE

Nullable

The date of the next move operation.

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

DUPLICATION_STATUS

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.

Examples

Example 1 - Create a table view of volumes by serial number including the status, sequence, media class, location, expiration and expiration dates:

SELECT VOLUME_SERIAL, SEQUENCE, VOLUME_STATUS, MEDIA_CLASS, EXPIRATION_DATE, EXPIRATION, LOCATION FROM TABLE(QUSRBRM.MEDIA_SET_INFO('002063')) ORDER BY SEQUENCE

Example output:

VOLUME_SERIAL

SEQUENCE

VOLUME_STATUS

MEDIA_CLASS

EXPIRATION_DATE

EXPIRATION

LOCATION

 000003

1

ACTIVE

ULTRIUM3

-

PERM

TAPMLB01

002063

2

ACTIVE

ULTRIUM3

-

PERM

TAPMLB01

002065

3

ACTIVE 

ULTRIUM3

-

PERM

TAPMLB01



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