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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |