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.
Authorization: None required.
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