Backup Manager Database Views > Detailed View Descriptions (Data Domain)
  
Version 10.0.01
Detailed View Descriptions (Data Domain)
apt_v_ddm_compression_log
The apt_v_ddm_compression_log view contains a single row for each Data Domain compression log.
Table 3.65 apt_v_ddm_compression_log
Column Name
Data Type
Description
collection_time
DATE
Log record date
host_id
NUMBER
Foreign key to apt_v_server
last_7days_global_comp_factor
NUMBER
Ratio of pre-compression / (size after deduplication) within the last 7 days
last_7days_local_comp_factor
NUMBER
Ratio of (size after deduplication) / post-compression with the last 7 days
last_7days_post_comp_size_kb
NUMBER
Storage used after compression within the last 7 days
last_7days_pre_comp_size_kb
NUMBER
Data written before compression within the last 7 days
apt_v_ddm_disk
The apt_v_ddm_disk view contains a single row for each Data Domain Disk.
Table 3.66 apt_v_ddm_disk
Column Name
Data Type
Description
capacity_kb
NUMBER
Capacity in KiB
cumulative_kb_per_sec
NUMBER
Cumulative KiB per second
data_domain_disk_id
STRING
Data Domain disk ID
disk_id
NUMBER
Sequence generated primary key
disk_pct_busy
NUMBER
Disk percent busy
disk_state
NUMBER
Disk state
enclosure_id
NUMBER
Foreign key to apt_v_ddm_enclosure
firmware
STRING
Firmware
host_id
NUMBER
Foreign key to apt_v_server
last_updated
DATE
Date and time last updated
manufacturer_model
STRING
Disk manufacturer model
read_sectors_per_sec
NUMBER
Read sectors per second
serial_number
STRING
Disk serial number
spindle_group
NUMBER
Spindle group
write_sectors_per_sec
NUMBER
Write sectors per second
apt_v_ddm_disk_perf_log
The apt_v_ddm_disk_perf_log view contains a single row for each Data Domain disk performance log.
Table 3.67 apt_v_ddm_disk_perf_log
Column Name
Data Type
Description
collection_time
DATE
Log record date
cumulative_kb_per_sec
NUMBER
Cumulative KiB per second
disk_id
NUMBER
Foreign key to apt_v_ddm_disk
disk_pct_busy
NUMBER
Disk percent busy
host_id
NUMBER
Foreign key to apt_v_server
read_sectors_per_sec
NUMBER
Read sectors per second
write_sectors_per_sec
NUMBER
Write sectors per second
apt_v_ddm_enclosure
The apt_v_ddm_enclosure view contains a single row for each Data Domain Enclosure.
Table 3.68 apt_v_ddm_enclosure
Column Name
Data Type
Description
enclosure_id
NUMBER
Data Domain enclosure ID
host_id
NUMBER
Foreign key to apt_host
last_updated
DATE
Date and time last updated
model_number
STRING
Enclosure model number
serial_number
STRING
Serial number
slot_capacity
NUMBER
Slot capacity
apt_v_ddm_file_system
The apt_v_ddm_file_system view contains a single row for each Data Domain file system.
Table 3.69 apt_v_ddm_file_system
Column Name
Data Type
Description
archive_filesystem_clnble_kb
NUMBER
Estimated amount of recoverable free space from Archive
archive_filesystem_size_kb
NUMBER
Archive physical disk space available for data
archive_filesystem_used_kb
NUMBER
Archive physical space used for compressed data
archive_pre_comp_size_kb
NUMBER
Amount of virtual data stored on the archive Data Domain system
clean_schedule
STRING
Clean schedule
filesystem_cleanable_kb
NUMBER
File system cleanable in KiB
filesystem_id
NUMBER
Sequence generated primary key
filesystem_name
STRING
File system name
filesystem_size_kb
NUMBER
File system size in KiB
filesystem_status
NUMBER
File system status
filesystem_used_kb
NUMBER
File system used in KiB
host_id
NUMBER
Foreign key to apt_v_server
last_updated
DATE
Date and time last updated
pre_comp_size_kb
NUMBER
Pre-compression size in KiB
tier_type
STRING
Possible values: Active Tier, Archive Tier, or Total
apt_v_ddm_file_system_log
The apt_v_ddm_file_system_log view contains a single row for each Data Domain file system log.
Table 3.70 apt_v_ddm_file_system_log
Column Name
Data Type
Description
collection_time
DATE
Log record date
filesystem_cleanable_kb
NUMBER
File system cleanable in KiB
filesystem_id
NUMBER
Foreign key to apt_v_ddm_file_system
filesystem_size_kb
NUMBER
File system size in KiB
filesystem_used_kb
NUMBER
File system used in KiB
host_id
NUMBER
Foreign key to apt_v_server
pre_comp_size_kb
NUMBER
Pre-compression size in KiB
apt_v_ddm_logical_strg_unit
The apt_v_ddm_logical_strg_unit view contains a single row for each Data Domain logical storage unit.
Table 3.71 apt_v_ddm_logical_strg_unit
Column Name
Data Type
Description
host_id
NUMBER
Foreign key to apt_v_server
last_updated
DATE
Date and time last updated
logical_storage_unit_id
NUMBER
Sequence generated primary key
logical_storage_unit_name
STRING
Logical storage unit name
apt_v_ddm_server_license
Table 3.72 apt_v_ddm_server_license
Column Name
Data Type
Description
host_id
NUMBER
Foreign key to apt_v_server
license_Key
STRING
The characters of a valid license key.
license_feature
STRING
The name of the licensed feature.
last_updated
DATE
Date and time last updated.
apt_v_ddm_system
The apt_v_ddm_system view contains a single row for each Data Domain system.
Table 3.73 apt_v_ddm_system
Column Name
Data Type
Description
creation_date
STRING
Date and time the system was created in the database
filesys_encrypted_algor
STRING
File System encryption algorithm
host_id
NUMBER
Foreign key to apt_v_server
is_filesys_encrypted
STRING
Is File System encrypted'
is_filesys_locked
STRING
Is File System locked
last_updated
DATE
Date and time last updated
serial_number
STRING
Data Domain system serial number
server_timezone
STRING
Server time zone
apt_v_ddm_system_model
The apt_v_ddm_system_model view contains a single row for each Data Domain system model.
Table 3.74 apt_v_ddm_system_model
Column Name
Data Type
Description
ddm_system_model_number
STRING
Data Domain system model number
raw_capacity_kb
NUMBER
Raw capacity in KiB
apt_v_ddm_system_replication
The apt_v_ddm_system_replication view contains a single row for each Data Domain system replication.
Table 3.75 apt_v_ddm_system_replication
Column Name
Data Type
Description
connection_time
DATE
Connection time
context_number
NUMBER
Context number
dest_directory
STRING
Destination directory
error
STRING
Error
host_id
NJMBER
Foreign key from apt_v_server
last_updated
DATE
Date and time last updated
post_comp_received_kb
NUMBER
Post-compression KiB remaining
post_comp_sent_kb
NUMBER
Post-compression KiB sent
pre_comp_remaining_kb
NUMBER
Pre-compression KiB remaining
pre_comp_sent_kb
NUMBER
Pre-compression KiB sent
replication_throttle
NUMBER
Replication throttle
source_directory
STRING
Source directory
state
STRING
State
synced_of_time
STRING
Synced of time
apt_v_ddm_system_snapshot
The apt_v_ddm_system_snapshot view contains a single row for each Data Domain system snapshot.
Table 3.76 apt_v_ddm_system_snapshot
Column Name
Data Type
Description
created_date
DATE
Created date
host_id
NUMBER
Foreign key for apt_v_server
last_updated
DATE
Date and time last updated
mtree_name
STRING
Mtree name (Note that Mtrees were introduced with Data Domain OS v5.0.)
pre_compression_kb
NUMBER
Pre-compression KiB
retain_until_date
DATE
Retain until date
snapshot_name
STRING
Snapshot name
snapshot_status
STRING
Snapshot status
apt_v_ddm_tape
The apt_v_ddm_tape view contains a single row for each Data Domain tape.
Table 3.77 apt_v_ddm_tape
Column Name
Data Type
Description
compression_factor
NUMBER
Compression factor
host_id
NUMBER
Foreign key from apt_v_server
last_updated
DATE
Date and time last updated
tape_barcode
STRING
Tape barcode
tape_location
STRING
Tape location
tape_modified_time
DATE
Tape modified time
tape_pool_id
NUMBER
Foreign key from apt_v_ddm_tape_pool
tape_size_kb
NUMBER
Tape capacity in KiB
tape_state
STRING
Tape state
tape_type
STRING
Tape type
tape_used_kb
NUMBER
Tape used capacity in KiB
virtual_tape_library_id
NUMBER
apt_v_ddm_tape_drive
The apt_v_ddm_tape_drive view contains a single row for each Data Domain tape drive.
Table 3.78 apt_v_ddm_tape_drive
Column Name
Data Type
Description
host_id
NUMBER
Foreign key from apt_v_server
last_updated
DATE
Date and time last updated
model_number
STRING
Model number
revision
STRING
Revision
serial_number
STRING
Serial number
tape_drive_name
STRING
Tape drive name
tape_drive_status
NUMBER
Tape drive status
tape_volume
STRING
Tape volume
vendor
STRING
Vendor
virtual_tape_library_id
NUMBER
apt_v_ddm_tape_pool
The apt_v_ddm_tape_pool view contains a single row for each Data Domain tape pool.
Table 3.79 apt_v_ddm_tape_pool
Column Name
Data Type
Description
host_id
NUMBER
Foreign key from apt_host
last_updated
DATE
Date and time last updated
tape_pool_id
NUMBER
Sequence generated primary key
tape_pool_name
STRING
Tape pool name
apt_v_ddm_virtual_tape_lib
The apt_v_ddm_virtual_tape_lib view contains a single row for each Data Domain virtual tape library.
Table 3.80 apt_v_ddm_virtual_tape_lib
Column Name
Data Type
Description
host_id
NUMBER
Foreign key from apt_v_server
last_updated
DATE
Date and time last updated
model_number
STRING
Model number
revision
STRING
Revision
serial_number
STRING
Serial number
total_cartridge_access_ports
NUMBER
Total cartridge access ports
total_drives
NUMBER
Total drives
total_slots
NUMBER
Total slots
vendor
STRING
Vendor
virtual_tape_library_id
STRING
Sequence generated primary key
virtual_tape_library_name
STRING
Virtual tape library name
virtual_tape_library_status
NUMBER
Virtual tape library status