Storage Viewer for Backup Database Views > apt_v_tsm_tape_library
  
Version 10.0.01
apt_v_tsm_tape_library
The apt_v_tsm_tape_library view provides TSM tape library details.
Table 3.176 apt_v_tsm_tape_library
Column Name
Data Type
Description
ACS_ID
NUMBER
ACS ID
CONTROLLING_SERVER
STRING
Media server name that is controlling the library
CONTROLLING_SERVER_ID
NUMBER
Foreign key to apt_v_server for the media server that is controlling the library
DESCRIPTION
STRING
Description of the library
DEVICE_NAME
STRING
Device name that controls the tape library
EXTERNAL_LIBRARY_MANAGER
STRING
External library manager name
EXTERNAL_MANAGER_ID
NUMBER
Foreign key to apt_v_server for the external library manager
IS_LANFREE
STRING
Is Lan-free: Y or N
IS_ONLINE
STRING
Is the library online: Y or N
IS_SHARED
STRING
Is library shared: Y or N
LIBRARY_ID
NUMBER
Foreign key to apt_v_tsm_tape_library.
LIBRARY_NAME
STRING
Custom name that can be assigned to the library
LIBRARY_TYPE
STRING
Library type name
MEDIA_CAPACITY
NUMBER
Total number of tapes loaded in the tape library as of last data collection
NBR_OF_DRIVES
NUMBER
Number of tape drives within the tape library
OBEY_MOUNT_RETENTION
STRING
Should the library obey retention mount: Y or N
PRIMARY_LIBRARY_MANAGER
STRING
Primary library manager name
PRIMARY_LIBRARY_MANAGER_ID
NUMBER
Foreign key to apt_v_server for the primary library manager
PRIVATE_CATEGORY
NUMBER
Private category
SCRATCH_CATEGORY
NUMBER
Scratch category
SERIAL_NBR
STRING
Serial number of the tape library
SERVER_ID
NUMBER
Foreign key to apt_v_server for the server with which this library is associated
SERVER_INSTANCE_ID
NUMBER
Foreign key to apt_v_server_instance for the TSM library instance
SERVER_INSTANCE_NAME
STRING
Name of the TSM server instance
SERVER_NAME
STRING
Server with which the library is associated
VENDOR_LIBRARY_NBR
NUMBER