Capacity Manager Database Views > Volume Manager Database Views
  
Version 9.2.00
Volume Manager Database Views
aps_v_vvm_host_disk
This view describes the disks managed by the Volume Manager.
Table 4.236 aps_v_vvm_host_disk
Column Name
Data Type
Description
capacity_kb
NUMBER
Capacity of the disk in KiB
host_disk_id
NUMBER
Foreign key from aps_v__host_disk
last_updated
DATE
Date and time last updated
vvm_disk_id
STRING
VVM Name for the Imported Disk
aps_v_vvm_lun
This view describes the LUNs mapped for the Volumes.
Table 4.237 aps_v_vvm_lun
Column Name
Data Type
Description
array_capacity_kb
NUMBER
Capacity of the array in KiB
array_name
STRING
Array name
disk_id
STRING
Disk ID from the aps_host_disk_table
file_system_capacity_kb
NUMBER
Capacity of the file system in KiB
file_system_id
NUMBER
Foreign key to file system details
file_system_last_update
DATE
Last updated date of the file system
file_system_name
STRING
File system name
file_system_used_kb
NUMBER
Used capacity in KiB
group_name
STRING
Group name
host_disk_id
NUMBER
Foreign key from aps_host_disk
host_id
NUMBER
Foreign key from apt_v_server
host_name
STRING
Host name
logical_unit_id
NUMBER
logical_unit_id from aps_hds_logical_unit
lun_capacity_kb
NUMBER
Capacity of the LUN in KiB
mount_point
STRING
Mount point from the aps_file_system table
plex_capacity_kb
NUMBER
Capacity of the Plex in KiB
plex_root_vvm_volume_id
NUMBER
Root volume ID from the aps_vvm_plex table
raw_disk_path
STRING
Raw disk path
storage_array_id
NUMBER
Foreign key from aps_storage_array
true_copy_vol_type
STRING
true_copy_vol_type from aps_hds_logical_unit
volume_group_id
NUMBER
Foreign key from aps_volume_group
volume_partition_capacity_kb
NUMBER
Capacity of the volume partition in KiB
volume_partition_id
NUMBER
Foreign key from aps_volume_partition
volume_partition_name
STRING
Volume partition name
vvm_plex_id
NUMBER
Plex Number
vvm_plex_name
STRING
Plex Name
vvm_sub_disk_capacity_kb
NUMBER
Capacity of the sub-disk in KiB
vvm_sub_disk_id
NUMBER
Foreign key from aps_v_vvm_sub_disk
vvm_sub_disk_name
STRING
Name of the sub-disk
vvm_volume_capacity_kb
NUMBER
Foreign key from aps_v_vvm_plex
vvm_volume_id
NUMBER
Foreign key from aps_v_vvm_volume
vvm_volume_name
STRING
Volume name
aps_v_vvm_plex
The aps_v_vvm_plex view describes the Plexes managed for the Volume Manager.
Table 4.238 aps_v_vvm_plex
Column Name
Data Type
Description
capacity_kb
NUMBER
Capacity in KiB
is_layered
STRING
Y indicates that its a layered plex similar to layered volumes
is_log
STRING
Y indicates that the plex is used for logging purposes.
last_updated
DATE
Date and time last updated
layout
STRING
Snapshot, Striped
root_vvm_volume_id
NUMBER
Foreign key from aps_v_vvm_volume
vm_volume_id
NUMBER
Foreign key from aps_v_vvm_volume
volume_group_id
NUMBER
Foreign key from aps_volume_group
vvm_plex_id
NUMBER
Unique ID
vvm_plex_name
STRING
Plex name
vvm_plex_state
STRING
State of the plex
aps_v_vvm_sub_disk
The aps_v_vvm_sub_disk view describes the sub-disks managed by the Volume Manager.
Table 4.239 aps_v_vvm_sub_disk
Column Name
Data Type
Description
capacity_kb
NUMBER
Capacity of the disk in KiB
is_dco
STRING
If a sub-disk is marked as DCO, it takes space but will not have the plex information reported.
is_layered
STRING
If it is layered, a disk Volume is available and is equal to volume Name. If not, a disk Partition is available and it matches the Partition.
last_updated
DATE
Date and time last updated
root_vvm_plex_id
NUMBER
Foreign key from aps_v_vvm_plex
root_vvm_volume_id
NUMBER
Foreign key from aps_v_vvm_volume
sub_disk_id
STRING
Sub-disk ID
sub_disk_id_suffix
STRING
Sub-disk ID suffix
vm_sub_disk_name
STRING
Sub-disk name
volume_group_id
NUMBER
Foreign key from aps_v_volume_group
volume_partition_id
NUMBER
Foreign key from aps_v_volume_partition
vvm_plex_id
NUMBER
Foreign key from aps_v_vvm_plex
vvm_sub_disk_id
NUMBER
Unique ID
vvm_volume_id
NUMBER
Foreign key from aps_v_vvm_volume
aps_v_vvm_volume
The aps_v_vvm_volume view describes the volumes managed by the Volume Manager.
Table 4.240 aps_v_vvm_volume
Column Name
Data Type
Description
capacity_kb
NUMBER
Capacity in KiB
drive_letter
STRING
Present only if Windows
last_updated
DATE
Date and time last updated
raid_type
STRING
Mirrored, Striped
vm_volume_id
NUMBER
Unique ID
volume_group_id
NUMBER
Foreign key from aps_volume_group
volume_partition_id
NUMBER
Foreign key from aps_volume_partition
volume_state
STRING
State of the volume
vvm_volume_name
STRING
Volume name