Storage Viewer for Backup Database Views > apt_v_tsm_storage_pool
  
Version 10.0.01
apt_v_tsm_storage_pool
The apt_v_tsm_storage_pool view provides TSM storage pool details.
Table 3.174 apt_v_tsm_storage_pool
Column Name
Data Type
Description
cache_migrated_files
STRING
Cache enabled indicator: Y or N
class_type
STRING
Class type
collocate
STRING
Co-location enabled indicator: Y or N
continue_copy_on_error
STRING
Continue copy indicator: Y or N
continue_migration
STRING
Continue indicator: Y or N
crc_data_checking
STRING
Cyclic redundancy checking enabled: Y or N
data_format
STRING
Format of the data
days_before_volume_reuse
NUMBER
Number of days (after all files have been deleted) before a volume can be rewritten or placed back into the scratch pool
description
STRING
Description of the storage pool
device_class_id
NUMBER
The device class assigned for the storage pool
device_class_name
STRING
Name of the device class
drive_encryption
STRING
Drive encryption from device class
est_mbyte_capacity
NUMBER
Estimated storage pool capacity
exists_in_catalog
STRING
Flag indicates that the pool exists in the catalog
high_migration_percentage
NUMBER
Percentage of storage pool occupancy, when the server will migrate files to the next storage pool
host_name
STRING
Name displayed in reports
instance_name
STRING
Name of the instance
is_migration_running
STRING
Status of migration: Y or N
low_migration_percentage
NUMBER
Percentage when the migration will cease
max_scratch_volumes
NUMBER
Maximum number of scratch volumes defined for the storage pool
max_size_mbytes
NUMBER
Maximum file size allowed
Certain special cases are handled as follows:
If TSM returns an empty MAXSIZE value, Storage Viewer stores it as 0
If TSM returns NOLIMIT, Storage Viewer stores it as 999999999999999999
media_access_type
STRING
read/write, read-only, or unavailable
migrated_pct
STRING
Migration percentage
migration_delay_days
NUMBER
Minimum number of days that migration can be delayed
migration_processes
NUMBER
The number of migration processes used for migrating files from this storage pool
next_storage_pool_id
NUMBER
Foreign key to apt_v_tsm_storage_pool for the ID of the next storage pool in the storage pool hierarchy, where data will be stored
next_storage_pool_name
NUMBER
Name of the next storage pool in the storage pool hierarchy, where data will be stored
overflow_location
STRING
Name of the location of volumes that were ejected from an automated or external library
reclaim_storage_pool_id
NUMBER
Foreign key to apt_v_tsm_storage_pool for the ID of the storage pool used for data from volumes that are reclaimed in this pool
reclaim_storage_pool_name
STRING
Name of the storage pool used for data from volumes that are reclaimed in this storage pool. Used for storage pools where the device class has only one mount point.
reclamation_threshold
NUMBER
Percentage of reclaimable space on a volume before the server begins reclaiming space for the volume
server_id
NUMBER
Foreign key to apt_v_server.
storage_pool_id
NUMBER
Foreign key to apt_v_tsm_storage_pool.
storage_pool_name
STRING
Storage pool name
storage_pool_type
STRING
Primary or Copy
utilization_pct
NUMBER
Utilization percentage