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

IBM Partnership

QUSRBRM.MEDIA_INFO View

Result Table

Examples

Example 1- Report volumes marked as full:

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

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

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