Backup Manager Database Views > Detailed View Descriptions (Data Domain)
  
Version 9.2.00
Detailed View Descriptions (Data Domain)
apt_v_ddm_disk
The apt_v_ddm_disk view contains a single row for each Data Domain Disk.
Table 3.64 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_enclosure
The apt_v_ddm_enclosure view contains a single row for each Data Domain Enclosure.
Table 3.65 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.66 apt_v_ddm_file_system
Column Name
Data Type
Description
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
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.67 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_system
The apt_v_ddm_system view contains a single row for each Data Domain system.
Table 3.68 apt_v_ddm_system
Column Name
Data Type
Description
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.69 apt_v_ddm_system_model
Column Name
Data Type
Description
ddm_system_model_number
STRING
Data Domain system model number. The model number is an indicator of the maximum allowable expansion of that model (total number of drive bays and shelves * largest disk). Possible model number values: DDX, GDA, DD890, DD860, DD670, DD640, DD620, DD160, DD2500, DD880, DD690, DD690g, DD660, DD630, DD610, DD580, DD580g, DD565, DD560g, DD530, DD510, DD460, DD430, DD410, DD200, DD140, DD120.
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.70 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.71 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.72 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.73 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.74 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.75 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