Column Name | Data Type | Description |
access_type | STRING | Access type |
cleanings_left | NUMBER | Number of cleanings left |
est_mbyte_capacity | NUMBER | Estimated capacity in MB |
instance_name | STRING | Instance name |
is_error_state | STRING | Indicates if the tape is in an error state |
is_scratch | STRING | Indicates if this is a scratch tape |
last_read_date | DATE | Date the tape was last read |
last_update_date | DATE | Date the tape was last updated |
last_updated | DATE | Date the data collection database was updated |
last_write_date | DATE | Date the tape last had write access |
library_id | NUMBER | Foreign key to apt_v_tape_library view. |
library_name | STRING | Library name |
library_slot_nbr | NUMBER | Library slot number |
location | STRING | Location of the tape |
media_name | STRING | Media name |
media_state | STRING | Media state |
media_status_name | STRING | Media status |
media_type_name | STRING | Media type |
mount_count | NUMBER | Mount count |
owner_instance_id | NUMBER | Owner instance ID |
pct_reclaim | NUMBER | Reclaimed percentage |
pct_utilized | NUMBER | Utilized percentage |
read_errors | NUMBER | Number of read errors |
server_host_name | STRING | Server host name |
server_id | NUMBER | Foreign key to apt_v_server |
server_instance_ID | NUMBER | Foreign key to apt_v_server_instance |
storage_pool_id | NUMBER | Foreign key to apt_v_tsm_storage_pool |
storage_pool_name | STRING | Storage pool name |
tape_media_id | NUMBER | Primary key for this view |
volume_type | STRING | Volume type |
write_errors | NUMBER | Number of write errors |
write_pass | NUMBER | Write pass |