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

IBM Partnership

QUSRBRM.MEDIA_SET_INFO Table Function

Parameters

Result Table

Examples

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