Column Name | Data Type | Description |
client_host_id | NUMBER | Foreign key to client host details |
client_host_name | STRING | Client host name |
client_ip_address | STRING | Client IP address |
disk_id | STRING | Disk ID |
disk_size_gb | NUMBER | Disk size in GiB |
host_disk_id | NUMBER | Foreign key to host disk details |
logical_unit_id | NUMBER | Foreign key to logical unit details |
logical_unit_name | STRING | Logical unit name |
lun_size_gb | NUMBER | LUN size in GiB |
storage_array_id | NUMBER | Foreign key to storage array details |
storage_array_name | STRING | Storage array name |
vio_server_host_id | NUMBER | Foreign key to VIO server details |
vio_server_host_name | STRING | VIO server name |
vio_server_ip_address | STRING | VIO server IP address |
Column Name | Data Type | Description |
domain_id | NUMBER | Foreign key to the apt_v_domain view |
host_id | NUMBER | Foreign key to the apt_v_server view |
last_updated | DATE | Date and time last updated |
logical_serial_nbr | STRING | Logical Serial Number of the LPAR. |
lpar_id | NUMBER | LPAR Id from the collector |
os_version | STRING | OS Version running on the LPAR |
partition_id | NUMBER | System generated identifier for the Partition. Primary key in this view. |
partition_name | STRING | Name of the LPAR. |
partition_type | STRING | Type of the LPAR. This Provides the information about the LPAR whether its VIO Server or Client. |
profile_name | STRING | Profile Name of the LPAR Configuration. |
state | STRING | State of the LPAR. Possible values: Running |
virtual_system_id | NUMBER | Foreign key to the apt_v_vio_virtual_system view |
Column Name | Data Type | Description |
adapter_name | STRING | Name of the Virtual SCSI Adapter. e.g: vhost. |
client_lpar_id | NUMBER | LPAR ID of the Client to which it is connected |
client_slot_nbr | NUMBER | Slot Number of the Client |
last_updated | DATE | Date and time last updated |
partition_id | NUMBER | Foreign key to the apt_v_vio_partition view |
physical_location | STRING | Physical Location of the Virtual SCSI Adapter. |
server_slot_nbr | NUMBER | Slot Number on the VIO Server |
state | STRING | State of the Adapter |
vio_scsi_adapter_id | NUMBER | System generated identifier for the SCSI adapter. Primary key in this view. |
virtual_system_id | NUMBER | Foreign key to the apt_v_vio_virtual_system view |
Column Name | Data Type | Description |
is_ivm_available | STRING | Integrated Virtualization Manager (IVM) available or not |
last_updated | DATE | Date and time last updated |
partition_id | NUMBER | Foreign key to the apt_v_vio_partition view |
server_address | STRING | Server Address |
software_version | STRING | Software Version of the server |
vio_fix_pack | STRING | Version of the service pack |
virtual_system_id | NUMBER | Foreign key to the apt_v_vio_virtual_system view |
Column Name | Data Type | Description |
array_port_wwn_id | NUMBER | Foreign key to the aps_wwn table |
backing_device | STRING | DISK or Physical or Logical Volumes of the VIO Server. This should be used for Mapping to the Partition or Disk host Resources Entry of the Client |
client_lun_nbr | NUMBER | Client Lun Number as seen by the Client Disks Location. This should be used for Mapping for Client to VIOS. |
controller | NUMBER | Controller Number within the Physical Location. |
last_updated | DATE | Date and time last updated |
partition_id | NUMBER | Foreign key to the apt_v_vio_partition view |
physical_location | STRING | Physical Location of the Target Device. |
server_lun_nbr | NUMBER | LUN Number on the VIO Server. This field will be present if the whole disk is allocated to the Client. |
status | STRING | Status of the VTD |
target_device_name | STRING | Name of the Virtual Target Device. |
vio_scsi_adapter_id | NUMBER | Foreign key to the apt_v_vio_scsi_adapter view |
vio_target_device_id | NUMBER | System generated identifier for the Target device. Primary key in this view. |
virtual_system_id | NUMBER | Foreign key to the apt_v_vio_virtual_system view |
Column Name | Data Type | Description |
domain_id | NUMBER | Foreign key to the apt_v_domain view |
hmc_frame_name | STRING | IBM Frame Name as Managed by the HMC |
is_active | STRING | Whether the virtual system is active or not |
last_updated | DATE | Date and time last updated |
lpar_managed_by | STRING | VIOS Managed by the HMC or IVM with the possible values as HMC or IVM |
lpar_mgmt_name | STRING | HMC Name for HMC Managed VIOS. VIOS Name for IVM Managed VIOS. |
serial_nbr | STRING | Serial Number of the IBM Frame obtained from HMC or IVM. |
virtual_system_id | NUMBER | System generated identifier for the Virtual System. Primary key in this view. |
virtual_system_name | STRING | Name of the Virtual System |