Storage Viewer for Capacity Database Views > aps_v_emc_sym_logical_unit
  
Version 10.0.01
aps_v_emc_sym_logical_unit
The aps_v_emc_sym_logical_unit view contains a single row for each EMC Symmetrix logical unit.
Note: To use a storage group in a report template, use aps_v_emc_sym_map_strgrp_lun to join the relationship between an EMC Symmetrix LUN and a storage group.
Table 4.128 aps_v_emc_sym_logical_unit
Column Name
Data Type
Description
allocated_capacity_gb
NUMBER
Allocated capacity in GiB (calculated from KiB)
allocated_capacity_kb
NUMBER
Allocated capacity in KiB
array_family
STRING
Array family
array_group_id
NUMBER
Foreign key to array group (RAID group) details
array_name
STRING
Array name
bcv_device_assoc_cg_name
STRING
BCV device associated CG name
bcv_device_assoc_grp_name
STRING
BCV device associated group name
bcv_device_status
STRING
BCV device status
bcv_last_action_date
DATE
BCV last action date
bcv_mirror_state
STRING
BCV mirror state
bcv_split_pct
NUMBER
BCV split in percentage
bvc_pair_state
STRING
BCV pair state
clone_parent_logical_unit_id
NUMBER
Internally generated sequential ID that uniquely identifies the clone parent logical unit.
clone_state
STRING
Clone state defines the type of copy option used when creating clones: Precopy, Copy, or Copied.
device_group_name
STRING
Device group name
device_rdf_state
STRING
Device RDF state
device_rdf_status
STRING
Device RDF status
device_state
STRING
Device state
emc_rdf_group_id
NUMBER
Foreign key to EMC rdf group details
emc_sym_srp_id
NUMBER
Foreign key to EMC Symmetrix SRP details
emc_sym_storage_pool_id
NUMBER
Foreign key to EMC Symmetrix storage pool details
emulation_type
STRING
Device Emulation Type - whether FB or CKD
free_capacity_gb
NUMBER
Free capacity in GiB (calculated from KiB)
free_capacity_kb
NUMBER
Free capacity in KiB
group_name
STRING
Array group name in which this LUN resides
is_bound
STRING
Indicates if the device is bound (Y, N)
is_mapped
STRING
Y=Yes, N=No. The device is mapped to front end ports or not
is_mapped_not_masked
STRING
Y=Yes, N=No. The device is mapped to front end ports but not masked to a host or not
is_synchronized
STRING
Y=Yes, N=No. The device is synchronized or not
last_updated
DATE
Last updated date
logical_unit_id
NUMBER
Foreign key to logical unit details
logical_unit_name
STRING
Logical unit name
lun_type
STRING
LUN type
nbr_allocated_luns
NUMBER
Total number of allocated logical units on the parent of this LUN
nbr_of_luns
NUMBER
Number of logical units
normalized_raid_type
STRING
Normalized RAID type
object_id
STRING
Unique internal identifier for the logical unit
parental_logical_unit_id
NUMBER
Parent logical unit ID. Foreign key to logical unit details
pool_name
STRING
EMC Symmetrix storage pool name
raid_type
STRING
RAID type of used by the volume: possible values
disk - non-raided else RAID1,RAID2...RAID5 etc
rdf_grp_name
STRING
RDF (RA) Group Name
rdf_grp_nbr
NUMBER
RDF (RA) Group Number
rdf_mode
STRING
RDF mode
rdf_state
STRING
RDF state
rdf_type
STRING
RDF type
remote_device_rdf_state
STRING
Remote device RDF state
srp_name
STRING
EMC Symmetrix SRP name
std_device_cg_name
STRING
Standard device CG name
std_device_grp_name
STRING
Standard device group name
storage_array_id
NUMBER
Foreign key to storage array details
sym_lun_device_name
STRING
EMC Symmetrix LUN device name
total_capacity_gb
NUMBER
Total capacity in GiB
total_capacity_kb
NUMBER
Total capacity in KiB
used_capacity_gb
NUMBER
Used capacity in GiB (calculated from KiB)
used_capacity_kb
NUMBER
Used capacity in kilobytes
written_capacity_gb
NUMBER
Written capacity in GiB (calculated from KiB)
written_capacity_kb
NUMBER
Written capacity in KiB