QUSRBRM.MEDIA_INFO View Column Name change
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/BRMS_MEDIA object.
The following table describes the columns in the view. The schema is QUSRBRM.
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:
|
EXPIRATION | EXPIRATION | VARCHAR(8) Nullable | When the volume expires. The possible values are: PERM The 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. |
Example 1 : Report volumes that are marked as full.
|
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 system SYSA or SYSB for any ULTRIUM2 or ULTRIUM3 media class.
|
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.
|
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.
|
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 |
Privacy Policy | Cookie Policy | Impressum
From time to time, this website may contain technical inaccuracies and we do not warrant the accuracy of any posted information.
Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.