Capacity Manager Database Views > IBM XIV Array Views
  
Version 10.0.00
IBM XIV Array Views
The following view are not specific to a storage array or vendor product.
aps_v_xiv_cluster
The aps_v_xiv_cluster contains information about the XIV clusters.
Table 4.317 aps_v_xiv_cluster
Column Name
Data Type
Description
cluster_name
STRING
Name of the cluster
cluster_type
STRING
Cluster type
last_updated
DATE
Date and time last updated
system_name
STRING
System name
xiv_cluster_id
NUMBER
Primary key
xiv_storage_system_id
NUMBER
Foreign key to aps_v_xiv_storage_system
aps_v_xiv_component
The aps_v_xiv_component lists of all components within the XIV Array.
Table 4.318 aps_v_xiv_component
Column Name
Data Type
Description
component_id
STRING
Product related Component ID
is_functioning
STRING
Is the component functioning
last_updated
DATE
Date and time last updated
requires_service
STRING
Does this component require Service
status
STRING
Status of the component
system_name
STRING
System name
xiv_component_id
NUMBER
Primary key
xiv_storage_system_id
NUMBER
Foreign key to aps_v_xiv_storage_system
aps_v_xiv_consistency_group
The aps_v_xiv_consistency_group contains the XIV consistency group information.
Table 4.319 aps_v_xiv_consistency_group
Column Name
Data Type
Description
consistency_group_name
STRING
Consistency group name
is_mirrored
STRING
Is the consistency Group mirrored
last_updated
DATE
Date and time last updated
system_name
STRING
System name
xiv_consistency_group_id
NUMBER
Primary key
xiv_storage_pool_id
NUMBER
Foreign key to aps_v_xiv_storage_pool
xiv_storage_system_id
NUMBER
Foreign key to aps_v_xiv_storage_system
aps_v_xiv_fc_adaptor
The aps_v_xiv_fc_adaptor describes the Fibre Channel and ISCSI Port information.
Table 4.320 aps_v_xiv_fc_adaptor
Column Name
Data Type
Description
array_port_id
NUMBER
Foreign key to aps_v_array_port
component_id
STRING
Product related Component ID
configured_rate
NUMBER
Configured Speed in GBaud
current_rate
NUMBER
Current speed in GBaud
last_updated
DATE
Date and time last updated
max_supported_rate
NUMBER
maximum supported speed in GBaud
model_nbr
STRING
Model number
port_nbr
NUMBER
Port number
port_role
STRING
Port role
port_state
STRING
Port state. Online or Offline
port_wwn
STRING
Port WWN
system_name
STRING
System name
xiv_fc_adaptor_id
NUMBER
Primary key
xiv_storage_system_id
NUMBER
Foreign key to aps_v_xiv_storage_system
aps_v_xiv_host_interface
The aps_v_xiv_host_interface contains the XIV host interface information.
Table 4.321 aps_v_xiv_host_interface
Column Name
Data Type
Description
host_id
NUMBER
Foreign key to apt_v_server
last_updated
DATE
Date and time last updated
os_type
STRING
Host OS type
port_wwn_id
NUMBER
Foreign key to aps_wwn table
system_name
STRING
System name
xiv_cluster_id
NUMBER
Foreign key to aps_v_xiv_cluster
xiv_host_interface_id
NUMBER
Primary key
xiv_storage_system_id
NUMBER
Foreign key to aps_v_xiv_storage_system
aps_v_xiv_ip_interface
The aps_v_xiv_ip_interface contains the Management IP Addresses information for the XIV.
Table 4.322 aps_v_xiv_ip_interface
Column Name
Data Type
Description
gateway
STRING
Default Gateway of the interface
interface_type
STRING
Type of the interface. Possible Values: iSCSI or Management
ip_interface_name
STRING
IP interface name
last_updated
DATE
Date and time last updated
netmask
STRING
Network mask
system_name
STRING
System name
up_address
STRING
IP address
xiv_ip_interface_id
NUMBER
Primary key
xiv_storage_system_id
NUMBER
Foreign key to aps_v_xiv_storage_system
aps_v_xiv_mirror
The aps_v_xiv_mirror contains mirror information for each Volume.
Table 4.323 aps_v_xiv_mirror
Column Name
Data Type
Description
current_role
STRING
Role of the mirror
designation
STRING
Indicates whether its Primary or Secondary Mirror Data.
is_active
STRING
Is mirror active
is_connected
STRING
Indicates the LinkUp Status for the Mirror
is_operational
STRING
Is the mirror operational
last_replicated_snapshot_date
DATE
last replicated snapshot date
last_updated
DATE
Date and time last updated
local_peer_name
STRING
Name of the mirror on Local
mirror_object
STRING
Describes whether the Mirror Name is Volume or Consistency Group.
remote_consistency_group_id
NUMBER
Foreign key to aps_v_xiv_consistency_group
remote_peer_name
STRING
Name of the Remote Target Volume or Consistency Group of the Mirror
remote_volume_id
NUMBER
Foreign key to aps_v_xiv_volume
sync_state
STRING
Mirror Synchronization state
sync_type
STRING
Type of the Mirror Synchronization
system_name
STRING
System name
xiv_consistency_group_id
NUMBER
Foreign key to aps_v_xiv_consistency_group
xiv_mirror_id
NUMBER
Primary key
xiv_storage_system_id
NUMBER
Foreign key to aps_v_xiv_storage_system
xiv_target_id
NUMBER
Foreign key to aps_v_xiv_target
xiv_volume_id
NUMBER
Foreign key to aps_v_xiv_volume
aps_v_xiv_physical_disk
The aps_v_xiv_physical_disk contains disk list information for the XIV.
Table 4.324 aps_v_xiv_physical_disk
Column Name
Data Type
Description
capacity_kb
NUMBER
Total capacity in KiB
component_id
STRING
Component ID
firmware_version
STRING
Firmware version
last_updated
DATE
Date and time last updated
model
STRING
Model
serial_nbr
STRING
Serial Number
system_name
STRING
System name
usable_size_kb
NUMBER
Usable capacity in KiB
xiv_physical_disk_id
NUMBER
Primary key
xiv_storage_system_id
NUMBER
Foreign key to aps_v_xiv_storage_system
aps_v_xiv_storage_pool
The aps_v_xiv_storage_pool contains the Storage Pool Information.
Table 4.325 aps_v_xiv_storage_pool
Column Name
Data Type
Description
free_hard_size_kb
NUMBER
Free hard size in KiB
free_soft_size_kb
NUMBER
Free soft size in KiB
is_locked
STRING
Is storage pool locked
is_thin_provisioned
STRING
Is storage pool thin provisioned
last_updated
DATE
Date and time last updated
lock_behaviour
STRING
Lock behavior
snapshot_size_kb
NUMBER
Snapshot size in KiB
storage_pool_name
STRING
Storage pool name
system_name
STRING
System name
total_hard_size_kb
NUMBER
Total hard size in KiB
total_soft_size_kb
NUMBER
Total soft size in KiB
used_by_snapshot_kb
NUMBER
Capacity used by snapshots in KiB
used_by_volume_kb
NUMBER
Capacity used by Volumes in KiB
xiv_storage_pool_id
NUMBER
Primary key
xiv_storage_system_id
NUMBER
Foreign key to aps_v_xiv_storage_system
aps_v_xiv_storage_system
The aps_v_xiv_storage_system contains XIV Array related information.
Table 4.326 aps_v_xiv_storage_system
Column Name
Data Type
Description
domain_id
NUMBER
Foreign key to apt_v_domain
free_hard_kb
NUMBER
Free Hard size in KiB
free_soft_kb
NUMBER
Free Soft size in KiB
iscsi_name
STRING
iSCSI Name of XIV
last_updated
DATE
Date and time last updated
machine_model
STRING
Machine model
machine_type
STRING
Machine type
max_pool_size_kb
NUMBER
Maximum pool size in KiB
nbr_allocated_luns
NUMBER
Number of allocated luns
nbr_of_luns
NUMBER
Number of luns
nbr_of_spare_disks
NUMBER
Number of spare disks
nbr_of_spare_modules
NUMBER
Number of spare modules
nbr_of_target_spare_disks
NUMBER
Number of target spare disks
nbr_of_target_spare_modules
NUMBER
Number of target spare modules
serial_nbr
STRING
Serial number
system_id
NUMBER
Product related system ID
system_name
STRING
System name
system_time
DATE
System date and time
system_version
STRING
System version
total_free_kb
NUMBER
Total Soft size in KiB
total_hard_kb
NUMBER
Total Hard size in KiB
xiv_storage_system_id
NUMBER
Primary key
aps_v_xiv_target
The aps_v_xiv_target contains the XIV Target definitions.
Table 4.327 aps_v_xiv_target
Column Name
Data Type
Description
is_connected
STRING
Is the target connected
iscsi_name
STRING
iSCSI name
last_updated
DATE
Date and time last updated
scsi_type
STRING
SCSI type
target_storage_system_id
NUMBER
Foreign key to aps_v_xiv_storage_system
target_storage_system_name
STRING
Target storage system name
system_name
STRING
System name
xiv_storage_system_id
NUMBER
Foreign key to aps_v_xiv_storage_system
xiv_target_id
NUMBER
Primary key
aps_v_xiv_target_connect
The aps_v_xiv_target_connect lists a specified remote target connectivity definition for all the target definitions.
Table 4.328 aps_v_xiv_target_connect
Column Name
Data Type
Description
is_active
STRING
Is target connect active
is_connected
STRING
Is target connected
last_updated
DATE
Date and time last updated
remote_fc_adaptor_id
NUMBER
Target FC adaptor ID
remote_port_wwn
STRING
Target port WWN
system_name
STRING
System name
xiv_fc_adaptor_id
NUMBER
Foreign key to aps_v_xiv_fc_adaptor
xiv_ip_interface_id
NUMBER
Foreign key to aps_v_xiv_ip_interface
xiv_storage_system_id
NUMBER
Foreign key to aps_v_xiv_storage_system
xiv_target_connect_id
NUMBER
Primary key
xiv_target_id
NUMBER
Foreign key to aps_v_xiv_target
aps_v_xiv_volume
The aps_v_xiv_volume contains XIV volumes information.
Table 4.329 aps_v_xiv_volume
Column Name
Data Type
Description
capacity_blk
NUMBER
Capacity in blocks
delete_priority
NUMBER
Deletion priority for the volume
is_locked
STRING
Is volume locked
is_mirrored
STRING
Is volume mirrored
is_modified
STRING
Is volume modified
last_updated
DATE
Date and time last updated
master_volume_id
NUMBER
Master volume ID
serial_nbr
NUMBER
specifies SCSI serial number for volume
snapshot_date
DATE
Snapshot date
system_name
STRING
System name
total_capacity_kb
NUMBER
Total capacity in KiB
used_kb
NUMBER
Used volume in KiB
volume_name
STRING
Volume name
wwn
STRING
WWN
xiv_consistency_group
NUMBER
Foreign key to aps_v_xiv_consistency_group
xiv_storage_pool_id
NUMBER
Foreign key to aps_v_xiv_storage_pool
xiv_storage_system_id
NUMBER
Foreign key to aps_v_xiv_storage_system
xiv_volume_id
NUMBER
Primary key