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 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:
|
CARTRIDGE_TYPE | TYPE | VARCHAR(10) Nullable | The cartridge type is reflected. The possible values are:
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:
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:
|
EXPIRATION | EXPIRATION | VARCHAR(8) Nullable | When the volume expires. The possible values are:
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:
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:
|
SERIAL_SET | SERIAL | VARCHAR(3) | Indicates whether the volume is part of a serial set. The possible values are:
|
PARALLEL_SET | PARALLEL | VARCHAR(3) | Indicates whether the volume is part of a parallel set. The possible values are:
|
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:
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 |