Capacity Manager Database Views > HP 3PAR Array Database Views
  
Version 9.2.00
HP 3PAR Array Database Views
aps_v_h3p_array_group
The aps_v_h3p_array_group contains a single row for each HP 3PAR array group.
Table 4.208 aps_v_h3p_array_group
Column Name
Data Type
Description
allocated_capacity_gb
NUMBER
Allocated configured capacity in GiB.
allocation_unit_gb
NUMBER
Growth increment allocated when Storage Volume or Dynamic Pool set to grow on demand.
array_group_id
NUMBER
Foreign key to aps_array_group.
array_grp_operational_status
STRING
Operational status for array group.
current_space_used_gb
NUMBER
Space being used by all Storage Volumes allocated from pool, including RAID overhead.
disk_device_type
NUMBER
Disk device type.
free_capacity_gb
NUMBER
Free configured capacity in GiB.
group_name
STRING
Name of the array group.
h3p_storage_system_id
NUMBER
Foreign key to aps_v_h3p_storage_system.
last_updated
DATE
Last updated date.
low_space_warning_threshold
NUMBER
Percentage low space warning threshold.
object_id
STRING
Unique internal identifier for the array group.
pool_type
NUMBER
Instance of TPD_Storage Pool, instance of TPD_DynamicStoragePool.
snapdata_warning_limit_gb
NUMBER
Warning if space allocated exceeds this amount.
space_limit_determination
NUMBER
Space limit determination.
space_limit_gb
NUMBER
Space limit in GiB.
system_name
STRING
System name.
thin_provision_metadata_gb
NUMBER
Size of meta data consumed by pool.
total_capacity_gb
NUMBER
Total configured capacity in GiB.
usable_capacity_gb
NUMBER
Usable capacity after RAID overhead.
used_snapadmin_metadata_gb
NUMBER
Actually allocated snapshot admin in GiB.
used_snapadmin_space_gb
NUMBER
Allocated for snapshot admin space in GiB.
used_snapdata_metadata_gb
NUMBER
Actually allocated not including RAID overhead.
used_snapdata_space_gb
NUMBER
Allocated for snapshot data in pool, not including RAID overhead.
used_space_gb
NUMBER
Consumed space in GiB.
aps_v_h3p_fc_port
The aps_v_h3p_fc_port contains a single row for each HP 3PAR array port.
Table 4.209 aps_v_h3p_fc_port
Column Name
Data Type
Description
active_cos
STRING
Active COS.
active_fc_type
STRING
Active port type.
class_support
NUMBER
Class support.
connection_type
NUMBER
Connection type.
device_type
NUMBER
Device type.
fc_configuration
NUMBER
Port configuration.
fc_device_id_ext
STRING
Unique identifier for FC port.
fc_operational_status
STRING
Operational status for FC port.
fc_other_operational_status
STRING
Other operational status.
fc_speed
NUMBER
FC port speed.
fc_topology
NUMBER
Topology.
fc_vcn
NUMBER
VCN.
h3p_node_id
NUMBER
Foreign key to aps_h3p_node.
h3p_storage_system_id
NUMBER
Foreign key to aps_v_h3p_storage_system.
is_auto_sense
STRING
Auto sense indicator.
is_full_duplex
STRING
Full duplex indicator.
last_updated
DATE
Last updated date.
max_speed
NUMBER
Maximum speed.
object_id
STRING
A unique identifier for array port.
permanent_address
STRING
Permanent address.
port_id
NUMBER
Foreign key to aps_array_port.
port_name
STRING
Port name.
port_nbr
NUMBER
Port number.
port_type
NUMBER
Port type.
port_wwn_id
NUMBER
Foreign key to port world wide name detail.
system_name
STRING
System name.
usage_restriction
NUMBER
Usage restriction.
aps_v_h3p_iscsi_port
The aps_v_h3p_iscsi_port contains a single row for each HP 3PAR array port.
Table 4.210 aps_v_h3p_iscsi_port
Column Name
Data Type
Description
h3p_node_id
NUMBER
Foreign key to aps_h3p_node.
h3p_storage_system_id
NUMBER
Foreign key to aps_v_h3p_storage_system.
is_auto_sense
STRING
Auto sense indicator.
is_full_duplex
STRING
Full duplex.
iscsi_device_id_ext
STRING
Unique identifier for ISCSI port.
last_updated
DATE
Last updated date.
network_address
STRING
Network address.
object_id
STRING
A unique identifier for array port.
operational_status
STRING
Operational status for ISCSI port.
other_operational_status
STRING
Other operational status.
port_id
NUMBER
Foreign key to aps_array_port.
port_name
STRING
Port name.
port_nbr
NUMBER
Port number.
port_type
NUMBER
Port type.
port_wwn_id
NUMBER
Foreign key to port world wide name details.
system_name
STRING
System name.
aps_v_h3p_ldev
The aps_v_h3p_ldev contains a single row for each HP 3PAR logical device.
Table 4.211 aps_v_h3p_ldev
Column Name
Data Type
Description
extent_status
STRING
Extent status.
h3p_ldev_id
NUMBER
System generated identifier. Primary key in this view.
h3p_storage_system_id
NUMBER
Foreign key to aps_v_h3p_storage_system.
last_updated
DATE
Last updated date.
ldev_device_id_ext
STRING
Unique identifier for logical device.
ldev_operational_status
STRING
Operational status for logical device.
raw_capacity_gb
NUMBER
Raw capacity in GiB.
system_name
STRING
System name.
usable_capacity_gb
NUMBER
Usable capacity in GiB.
aps_v_h3p_logical_unit
The aps_v_h3p_logical_unit contains a single row for each HP 3PAR logical unit.
Table 4.212 aps_v_h3p_logical_unit
Column Name
Data Type
Description
backup_node1
NUMBER
Backup node one.
backup_node2
NUMBER
Backup node two.
consumable_admin_gb
NUMBER
Consumable admin capacity in GiB.
consumable_copy_gb
NUMBER
Consumable copy capacity in GiB.
current_availability
NUMBER
Current availability.
data_redundancy
NUMBER
Data redundancy.
date_created
DATE
Date created.
device_nbr
NUMBER
Device number.
disk_device_type
NUMBER
Disk device type.
expiration_time
DATE
Expiration time.
export_state
NUMBER
Export state.
h3p_storage_system_id
NUMBER
Foreign key to aps_v_h3p_storage_system.
is_thinly_provisioned
STRING
Thin provisioned indicator.
is_underlying_redundancy
STRING
Underlying redundancy indicator.
last_updated
DATE
Last updated date.
logical_unit_id
NUMBER
Foreign key to aps_logical_unit.
logical_unit_name
STRING
Logical unit name.
lun_access
NUMBER
Logical unit access.
lun_domain
STRING
Logical unit domain.
lun_operational_status
STRING
Operational status for logical unit.
lun_other_operational_status
STRING
Other operational status.
lun_policy
NUMBER
Logical unit policy.
master_node
NUMBER
Master node.
name_format
NUMBER
Name format.
name_space
NUMBER
Name space.
object_id
STRING
Unique identifier for logical unit.
package_redundancy
NUMBER
Package redundancy.
preferred_availability
NUMBER
Preferred availability.
raw_admin_gb
NUMBER
Raw admin capacity in GiB.
raw_blocks_gb
NUMBER
Raw blocks in GiB.
raw_copy_gb
NUMBER
Raw copy capacity in GiB.
retention_time
DATE
Retention time.
set_data
NUMBER
Set data.
set_size
NUMBER
Set size.
snap_dsp_name
STRING
Snap dsp name.
snap_space_allocation_limit
NUMBER
Snap space allocation limit.
snap_space_allocation_warning
NUMBER
Snap space allocation warning.
system_name
STRING
System name.
total_capacity_gb
NUMBER
Total capacity in GiB.
used_snapshot_admin_space_gb
NUMBER
Used snapshot admin space in GiB.
used_snapshot_data_space_gb
NUMBER
Used snapshot data space in GiB.
user_dsp_name
STRING
User dsp name.
user_space_allocation_limit
NUMBER
User space allocation limit.
user_space_allocation_warning
NUMBER
User space allocation warning.
volume_type
NUMBER
Volume type.
aps_v_h3p_map_ldev_lun
The aps_v_h3p_map_ldev_lun contains a single row for each HP 3PAR logical device and logical unit mapping.
Table 4.213 aps_v_h3p_map_ldev_lun
Column Name
Data Type
Description
device_nbr
NUMBER
Device number.
h3p_ldev_id
NUMBER
Foreign key to aps_h3p_ldev.
h3p_storage_system_id
NUMBER
Foreign key to aps_v_h3p_storage_system.
last_updated
DATE
Last updated date.
ldev_device_id_ext
STRING
Unique identifier for logical device.
logical_unit_id
NUMBER
Foreign key to aps_logical_unit.
logical_unit_name
STRING
Logical unit name.
object_id
STRING
Unique identifier for logical unit.
raw_capacity_gb
NUMBER
Raw capacity in GiB.
system_name
STRING
System name.
total_capacity_gb
NUMBER
Total capacity in GiB.
usable_capacity_gb
NUMBER
Usable capacity in GiB.
aps_v_h3p_map_ldev_pdev
The aps_v_h3p_map_ldev_pdev contains a single row for each HP 3PAR logical device and physical device mapping.
Table 4.214 aps_v_h3p_map_ldev_pdev
Column Name
Data Type
Description
capacity_gb
NUMBER
Capacity in gigabytes.
disk_type
STRING
Disk type.
h3p_ldev_id
NUMBER
Foreign key to aps_h3p_ldev.
h3p_storage_system_id
NUMBER
Foreign key to aps_v_h3p_storage_system.
last_updated
DATE
Last updated date.
ldev_device_id_ext
STRING
Unique identifier for logical device.
pdev_id
NUMBER
Foreign key to aps_pdev.
pdev_name
STRING
Physical device name.
raw_capacity_gb
NUMBER
Raw capacity in GiB.
rpm
NUMBER
RPM.
serial_nbr
STRING
Serial number.
system_name
STRING
System name.
usable_capacity_gb
NUMBER
Usable capacity in GiB.
aps_v_h3p_node
The aps_v_h3p_node contains a single row for each HP 3PAR node.
Table 4.215 aps_v_h3p_node
Column Name
Data Type
Description
bios_version
STRING
Bios version.
cache_enabled
NUMBER
The number of cache enabled.
description
STRING
Description for node.
element_name
STRING
Element name.
h3p_node_id
NUMBER
System generated identifier. Primary key to this view.
h3p_storage_system_id
STRING
Foreign key to aps_v_h3p_storage_system.
is_cluster
STRING
Cluster indicator.
is_master
STRING
Master node indicator.
is_online
STRING
Online indicator.
kernel_version
STRING
Kernel version.
last_updated
DATE
Last updated date.
node_name
STRING
Name of the node system.
node_operational_status
STRING
Operational status for node.
node_other_operational_status
STRING
Other operational status.
node_position
NUMBER
Node position.
system_name
STRING
System name.
aps_v_h3p_node_cpu
The aps_v_h3p_node_cpu contains a single row for each HP 3PAR node cpu.
Table 4.216 aps_v_h3p_node_cpu
Column Name
Data Type
Description
bus_speed
NUMBER
Bus speed.
element_name
STRING
Element name.
h3p_node_cpu_id
NUMBER
System generated identifier. Primary key in this view.
h3p_node_id
NUMBER
Foreign key to aps_h3p_node.
h3p_storage_system_id
NUMBER
Foreign key to aps_v_h3p_storage_system.
last_updated
DATE
Last updated date.
manufacturer
STRING
Manufacturer.
ncpu_device_id_ext
STRING
Unique identifier for node cpu.
ncpu_model
STRING
Model.
ncpu_role
STRING
Node cpu role.
node_name
STRING
Name of the node
system_name
STRING
System name.
aps_v_h3p_pdev
The aps_v_h3p_pdev contains a single row for each HP 3PAR physical device.
Table 4.217 aps_v_h3p_pdev
Column Name
Data Type
Description
cage_type
NUMBER
Cage type.
capacity_gb
NUMBER
Capacity in gigabytes.
chunk_normal_unused_fail
NUMBER
Chunk normal unused failed capacity.
chunk_normal_unused_free
NUMBER
Chunk normal unused free capacity.
chunk_normal_unused_uninit
NUMBER
Chunk normal unused uninit capacity.
chunk_normal_used_fail
NUMBER
Chunk normal used failed capacity.
chunk_normal_used_ok
NUMBER
Chunk normal used ok capacity.
chunk_size
NUMBER
Chunk size.
chunk_spare_unused_fail
NUMBER
Chunk spare unused failed capacity.
chunk_spare_unused_free
NUMBER
Chunk spare unused free capacity.
chunk_spare_unused_uninit
NUMBER
Chunk spare unused uninit capacity.
chunk_spare_used_fail
NUMBER
Chunk spare used failed capacity.
chunk_spare_used_ok
NUMBER
Chunk spare used ok capacity.
correctable_read_error
NUMBER
Correctable read error.
correctable_write_error
NUMBER
Correctable write error.
disk_type
STRING
Disk type.
esi_state
NUMBER
ESI state.
firmware_status
NUMBER
Firmware status.
h3p_storage_system_id
NUMBER
Foreign key to aps_v_h3p_storage_system.
initiator_porta
STRING
Initiator port A.
initiator_portb
STRING
Initiator port B.
is_esi
STRING
ESI.
is_ld_allocatable
STRING
Logical device allocatable indicator.
last_updated
DATE
last updated date.
pdev_id
NUMBER
Foreign key to aps_pdev.
pdev_name
STRING
Pdev name.
pdev_operational_status
STRING
Operational status for pdev.
pdev_other_operational_status
STRING
Other operational status.
pdev_position
NUMBER
Position.
primary_port_path
STRING
Primary port path.
rpm
NUMBER
Revolutions per minute.
serial_nbr
STRING
Serial Number.
state_on_loopa
NUMBER
State on loop A.
state_on_loopb
NUMBER
State on loop B.
system_name
STRING
System name.
uncorrectable_read_error
NUMBER
Uncorrectable read error.
uncorrectable_write_error
NUMBER
Uncorrectable write error.
aps_v_h3p_storage_system
The aps_v_h3p_storage_system contains a single row for each HP 3PAR storage system.
Table 4.218 aps_v_h3p_storage_system
Column Name
Data Type
Description
alloc_snapadmin_gb
NUMBER
Allocated snapshot admin in GiB.
alloc_snapdata_gb
NUMBER
Allocated snapshot data capacity in GiB.
build_number
NUMBER
Build number.
free_hard_gb
NUMBER
Free hard size in GiB.
free_soft_gb
NUMBER
Free soft size in GiB.
h3p_storage_system_id
NUMBER
Foreign key to aps_v_storage_array.
install_date
DATE
Install date.
ipv4_address
STRING
IP v4 address.
last_updated
DATE
Last updated date.
location
STRING
Location.
machine_model
STRING
Machine model.
machine_type
STRING
Machine type.
max_space_limit_gb
NUMBER
Max space limit in GiB.
nbr_allocated_luns
NUMBER
Number of allocated LUNs.
nbr_of_10gb_ports
NUMBER
Number of 10gb ports.
nbr_of_1gb_ports
NUMBER
Number of 1gb ports.
nbr_of_assoc_ldev
NUMBER
Number of associated logical devices.
nbr_of_hosts
NUMBER
Number of hosts.
nbr_of_logical_disks
NUMBER
Number of logical disks.
nbr_of_luns
NUMBER
Number of luns.
operational_status
STRING
Operational status for storage system.
primary_owner_contact
STRING
Primary owner contact.
primary_owner_name
STRING
Primary owner name.
serial_nbr
STRING
Serial number.
system_name
STRING
System name.
system_version
STRING
System version.
time_zone
STRING
Time zone.
total_free_gb
NUMBER
Total soft size in GiB.
total_hard_gb
NUMBER
Total hard size in GiB.
vlun_capacity_gb
NUMBER
Virtual logical unit capacity in GiB.