Capacity Manager Database Views > EMC Symmetrix Array Database Views
  
Version 10.0.01
EMC Symmetrix Array Database Views
aps_v_emc_sym_array_group
The aps_v_emc_sym_array_group view contains a single row for each EMC Symmetrix array group.
Table 4.126 aps_v_emc_sym_array_group
Column Name
Data Type
Description
allocated_capacity_gb
NUMBER
Allocated configured capacity in Gigabytes
array_group_id
NUMBER
Foreign key to array group (RAID group) details
array_name
STRING
Array name
chassis_nbr
NUMBER
Chassis Number
emc_sym_srp_id
NUMBER
Foreign key to EMC Symmetrix SRP details
emc_sym_tier_id
NUMBER
Foreign key to EMC symmetrix tier details
free_capacity_gb
NUMBER
Free configured capacity in Gigabytes
group_name
STRING
Name of the server group
group_nbr
NUMBER
Group Number
is_external
STRING
Whether the Array Group is external or not
last_updated
DATE
Last updated date
object_id
STRING
Unique internal identifier for the array group
overhead_gb
NUMBER
Overhead in Gigabytes
raid_type
STRING
RAID type of used by the volume: possible values disk - non raided else RAID1,RAID2...RAID5 etc.
srp_name
STRING
EMC Symmetrix SRP name
storage_array_id
NUMBER
Foreign key to storage array details
tier_name
STRING
Tier name
total_capacity_gb
NUMBER
Total configured capacity in Gigabytes
usable_capacity_gb
NUMBER
Usable capacity after RAID overhead
usable_free_capacity_gb
NUMBER
Usable free capacity in GiB
usable_used_capacity_gb
NUMBER
Usable used capacity in GiB
aps_v_emc_sym_fast_policy
The aps_v_emc_sym_fast_policy view contains a single row for each EMC Symmetrix FAST policy.
Table 4.127 aps_v_emc_sym_fast_policy
Column Name
Data Type
Description
array_name
STRING
Array name
emc_sym_fast_policy_id
NUMBER
System-generated identifier for the FAST policy. Primary key in this view
emulation_type
STRING
Emulation type
fast_policy_name
STRING
FAST policy name
last_updated
DATE
Last updated date
storage_array_id
NUMBER
Foreign key to storage array details
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
aps_v_emc_sym_map_pol_strgrp
The aps_v_emc_sym_map_pol_tier view can be used for mapping between FAST policy and the storage group.
Table 4.129 aps_v_emc_sym_map_pol_strgrp
Column Name
Data Type
Description
array_name
STRING
Array name
emc_sym_fast_policy_id
NUMBER
Foreign key to EMC symmetrix FAST policy details
emc_sym_storage_grp_id
NUMBER
Foreign key to EMC symmetrix storage group details
emc_sym_tier_id
NUMBER
Foreign key to EMC symmetrix tier details
fast_policy_name
STRING
FAST policy name
last_updated
DATE
Last updated date
priority
NUMBER
Priority of the storage group in the policy
storage_array_id
NUMBER
Foreign key to storage array details
storage_group_name
STRING
EMC Symmetrix storage group name
aps_v_emc_sym_map_pol_tier
The aps_v_emc_sym_map_pol_tier view can be used for mapping between FAST policy and tier.
Table 4.130 aps_v_emc_sym_map_pol_tier
Column Name
Data Type
Description
array_name
STRING
Array name
emc_sym_fast_policy_id
NUMBER
Foreign key to EMC Symmetrix FAST policy details
emc_sym_tier_id
NUMBER
Foreign key to EMC Symmetrix tier details
fast_policy_name
STRING
FAST policy name
last_updated
DATE
Last updated date
max_storage_group_pct
NUMBER
Maximum percent the tier can be used by the policy
storage_array_id
NUMBER
Foreign key to storage array details
tier_name
STRING
Tier name
aps_v_emc_sym_map_strgrp_lun
The aps_v_emc_sym_map_strgrp_lun view can be used for the mapping between the storage group and the logical unit.
Table 4.131 aps_v_emc_sym_map_strgrp_lun
Column Name
Data Type
Description
array_name
STRING
Array name
emc_sym_storage_grp_id
NUMBER
Foreign key to EMC Symmetrix storage group details
last_updated
DATE
Last updated date
logical_unit_id
NUMBER
Foreign key to logical unit details
logical_unit_name
STRING
Logical unit name
storage_array_id
NUMBER
Foreign key to storage array details
storage_group_name
STRING
EMC Symmetrix storage group name
aps_v_emc_sym_port
The aps_v_emc_sym_port view contains a single row for each EMC Symmetrix port.
Table 4.132 aps_v_emc_sym_port
Column Name
Data Type
Description
array_name
STRING
Array name
director_id
STRING
Director Identification
director_numeric_nbr
NUMBER
Director Numeric Number
director_slot_nbr
NUMBER
Director Slot Number
director_status
STRING
Director status
director_symbolic_nbr
STRING
Director Symbolic Number
director_type
STRING
Director type
emc_rdf_group_id
NUMBER
Foreign key to EMC rdf group details
emc_symmetrix_port_id
NUMBER
Foreign key to EMC Symmetrix port details
last_updated
DATE
Last updated date
node_wwn
STRING
The worldwide node name that is assigned to the symmetrix port
node_wwn_id
NUMBER
Foreign key to WWN
prevent_auto_rdf_link_recovery
STRING
Prevent Automatic RDF Link Recovery
prevent_ra_online_upon_poweron
STRING
Prevent RAs Online Upon Power ON
rdf_grp_name
STRING
RDF (RA) Group Name
rdf_grp_nbr
NUMBER
RDF (RA) Group Number
remote_symmetrix_id
STRING
Remote Symmetrix ID it got connected to
remote_symmetrix_port_id
NUMBER
Foreign key to remote EMC symmetrix port details
remote_symmetrix_symbolic_nbr
STRING
Remote RDF (RA) Director Symbolic
storage_array_id
NUMBER
Foreign key to storage array details
aps_v_emc_sym_srp
The aps_v_emc_sym_srp view contains a single row for each EMC Symmetrix storage resource pool (SRP).
Table 4.133 aps_v_emc_sym_srp
Column Name
Data Type
Description
allocated_capacity_gb
NUMBER
Indicates the sum of the device allocations, snapshot allocations, and SRDF/A DSE allocations on the SRP (Storage Resource Pool) in GiB
allocated_capacity_kb
NUMBER
Indicates the sum of the device allocations, snapshot allocations, and SRDF/A DSE allocations on the SRP (Storage Resource Pool) in KiB
array_name
STRING
Array name
creation_date
DATE
Date and time this SRP (Storage Resource Pool) was created
emc_sym_srp_id
NUMBER
Foreign key to EMC symmetrix SRP details
free_capacity_kb
NUMBER
It is the difference between the usable and the allocated capacity in KiB
last_updated
DATE
Last updated date
nbr_of_luns
NUMBER
Number of LUNs associated with the EMC Symmetrix SRP (Storage Resource Pool)
nbr_of_pdevs
NUMBER
Number of Physical Disks associated with the EMC Symmetrix SRP (Storage Resource Pool)
srp_name
STRING
Name of the Storage Resource Pool
storage_array_id
NUMBER
Foreign key to storage array details
subscribed_capacity_gb
NUMBER
Subscribed Capacity — It is sum of the sizes of all the thin devices subscribed against the SRP (Storage Resource Pool) in GiB
subscribed_capacity_kb
NUMBER
Subscribed Capacity — It is sum of the sizes of all the thin devices subscribed against the SRP (Storage Resource Pool) in KiB
subscribed_pct
NUMBER
Subscribed Capacity percentage — It is the percentage of the Usable Capacity used by thin devices
usable_capacity_gb
NUMBER
Indicates the usable capacity of all the disk groups in the SRP (Storage Resource Pool) in GiB
usable_capacity_kb
NUMBER
Indicates the usable capacity of all the disk groups in the SRP (Storage Resource Pool) in KiB
 
aps_v_emc_sym_storage_grp
The aps_v_emc_sym_storage_grp view contains a single row for each EMC Symmetrix storage group.
Table 4.134 aps_v_emc_sym_storage_grp
Column Name
Data Type
Description
array_name
STRING
Array name
emc_sym_srp_id
NUMBER
Foreign key to EMC Symmetrix SRP details
emc_sym_storage_grp_id
NUMBER
EMC Symmetrix storage group ID
is_fast_policy
STRING
Indicating if storage group is part of the FAST policy or not. Y/N
is_masking_views
STRING
Indicating if storage group has masking views or not. Y/N
last_updated
DATE
Last updated date
nbr_of_storage_groups
NUMBER
Existing Storage Group contains number of other Storage Group
parent_storage_grp_id
NUMBER
Foreign key into aps_v_emc_sym_storage_grp to locate the parent of this storage group if any
srp_name
STRING
EMC Symmetrix SRP name
storage_array_id
NUMBER
Foreign key to storage array details
storage_group_name
STRING
Storage group name
aps_v_emc_sym_storage_path
The aps_v_emc_sym_storage_path view contains a single row for each EMC Symmetrix storage path.
Table 4.135 aps_v_emc_sym_storage_path
Column Name
Data Type
Description
array_name
STRING
Array name
emc_sym_initiator_grp_id
NUMBER
Foreign key to EMC Symmetrix initiator group details
emc_sym_masking_view_id
NUMBER
Foreign key to EMC Symmetrix masking view details
emc_sym_port_grp_id
NUMBER
Foreign key to EMC Symmetrix port group details
emc_sym_storage_grp_id
NUMBER
Foreign key to EMC Symmetrix storage group details
initiator_group_name
STRING
EMC Symmetrix initiator group name
last_updated
DATE
Last updated date
masking_view_name
STRING
EMC Symmetrix masking view name
path_id
NUMBER
Path ID
port_group_name
STRING
EMC Symmetrix port group name
storage_array_id
NUMBER
Foreign key to storage array details
storage_group_name
STRING
Storage group name
aps_v_emc_sym_storage_pool
The aps_v_emc_sym_storage_pool view contains a single row for each EMC Symmetrix storage pool.
Table 4.136 aps_v_emc_sym_storage_pool
Column Name
Data Type
Description
array_name
STRING
Array name
dev_config
STRING
Device configuration
dev_emulation
STRING
Device emulation
emc_sym_storage_pool_id
NUMBER
Foreign key to EMC Symmetrix storage pool details
emc_sym_tier_id
NUMBER
Foreign key to EMC Symmetrix tier details
last_updated
DATE
Last updated date
pct
NUMBER
Percentage
pool_name
STRING
EMC Symmetrix storage pool name
storage_array_id
NUMBER
Foreign key to storage array details
subscribed_pct
NUMBER
Subscribed percentage
tier_name
STRING
EMC Symmetrix tier name
total_enabled_tracks_gb
NUMBER
Total enabled tracks in GiB
total_enabled_tracks_kb
NUMBER
Total enabled tracks in KiB
total_tracks_gb
NUMBER
Total tracks in GiB
total_tracks_kb
NUMBER
Total tracks in KiB
total_used_tracks_gb
NUMBER
Total used tracks in GiB
total_used_tracks_kb
NUMBER
Total used tracks in KiB
aps_v_emc_sym_storage_pool_log
The aps_v_emc_sym_storage_pool_log view contains a single row for each EMC Symmetrix storage pool log.
Table 4.137 aps_v_emc_sym_storage_pool_log
Column Name
Data Type
Description
array_name
STRING
Array name
available_capacity_gb
NUMBER
Available capacity in GiB (calculated from KiB)
available_capacity_kb
NUMBER
Available capacity in KiB
emc_sym_storage_pool_id
NUMBER
Foreign key to EMC Symmetrix storage pool details
log_date
DATE
Log date
pool_name
STRING
EMC Symmetrix storage pool name
storage_array_id
NUMBER
Foreign key to storage array details
subscribed_capacity_gb
NUMBER
Subscribed capacity in GiB (calculated from KiB)
subscribed_capacity_kb
NUMBER
Subscribed capacity in KiB
total_capacity_gb
NUMBER
Total capacity in GiB (calculated from KiB)
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 KiB
aps_v_emc_sym_tier
The aps_v_emc_sym_tier view contains a single row for each EMC Symmetrix tier.
Table 4.138 aps_v_emc_sym_tier
Column Name
Data Type
Description
array_name
STRING
Array name
emc_sym_tier_id
NUMBER
System generated identifier for the tier. Primary key in this view
storage_array_id
NUMBER
Foreign key to storage array details
tier_name
STRING
Tier name
tier_type
STRING
Tier Type: DP = Disk Group Provisioning, VP = Virtual Pools
disk_location
STRING
Whether the Disk is Located internally or Externally
emulation
STRING
Emulation of the Tier: CKD or FBA
allocated_capacity_gb
NUMBER
Allocated Capacity of tier in GiB
enabled_capacity_gb
NUMBER
Enabled capacity of the Tier in GiB
free_capacity_gb
NUMBER
Free capacity of the Tier in GiB
include_type
STRING
Indicates whether the Tier is static or dynamic
raid_type
STRING
RAID type of the Tier
disk_type
STRING
Disk Type of the Tier: EFD, FC, SATA
last_updated
DATE
Last updated date