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