MEDIA_LIBRARY_INFO view
The MEDIA_LIBRARY_INFO view returns information that can also be seen through the Work with Media Library Status (WRKMLBSTS) command interface.
The following table describes the columns in the view. The system name is MEDIA_INFO. The schema is QSYS2.
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
DEVICE_NAME | DEVICE | VARCHAR(10) | The name of the device. |
DEVICE_STATUS | DEVICE_STS | VARCHAR(20) | The status of the device. The most
common values are:
|
DEVICE_TYPE | DEVICE_TYP | VARCHAR(10) | The type of device. Contains the special value *RSRCNAME if the device type is determined by the resource in the RESOURCE_NAME column. |
DEVICE_MODEL | DEVICE_MDL | VARCHAR(10) | The model number of the device. Contains the special value *RSRCNAME if the device model is determined by the resource in the RESOURCE_NAME column. |
RESOURCE_NAME | RESOURCE | VARCHAR(10) Nullable
|
The name of the resource. Contains the null value if the DEVICE_STATUS column has a value of VARIED_OFF, or if the tape library does not have any associated tape resources. |
RESOURCE_STATUS | RSRC_STS | VARCHAR(11) Nullable
|
The status of the resource.
Contains the null value if the DEVICE_STATUS column has a value of VARIED_OFF, or if the tape library does not have any associated tape resources. |
RESOURCE_ALLOCATION_STATUS | ALLOCATION | VARCHAR(11) Nullable
|
Current allocation status for the
resource.
Contains the null value if the DEVICE_STATUS column has a value of VARIED_OFF, or if the tape library does not have any associated tape resources. |
RESOURCE_ALLOCATION
_PRIORITY |
ALLOC_PRTY | VARCHAR(4) | The priority of a job when requesting
a resource. 1 is highest priority, 99 is lowest. Can contain the following
special value:
|
INITIAL_MOUNT_WAIT_TIME | INIT_WAIT | VARCHAR(6) | The maximum amount of time a request
will wait for allocation of a tape resource for the initial mount.
Contains either a numeric string representing the number of minutes
or one of the following special values:
|
END_OF_VOLUME_MOUNT_WAIT
_TIME |
END_WAIT | VARCHAR(6) | The maximum amount of time a request
will wait for allocation of a tape resource for the end of volume
mount. Contains either a numeric string representing the number of
minutes or one of the following special values:
|
DEVICE_DESCRIPTION | DEVICE_DES | VARCHAR(50) | The text description of the device. |
Example
Return information about all media library devices.
SELECT * FROM QSYS2.MEDIA_LIBRARY_INFO