Capacity Manager Database Views > IBM VIO Database Views
  
Version 10.0.01
IBM VIO Database Views
apt_v_vio_disk_path
The apt_v_vio_disk_path view associates VIO Server with LUN.
Table 4.292 apt_v_vio_disk_path
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
apt_v_vio_guest_allocusage_log
The apt_v_vio_guest_allocusage_log view contains a single row for each VIO Guest historical storage usage.
Table 4.293 apt_v_vio_guest_allocusage_log
Column Name
Data Type
Description
host_id
NUMBER
Foreign key to host details
host_name
STRING
Host name
host_type
STRING
Host type
log_date
DATE
Date and time when the history was captured
total_volume_size_gb
NUMBER
Total volume size in GiB
total_volume_size_kb
NUMBER
Total volume size in KiB
used_volume_size_gb
NUMBER
Used volume size in GiB
used_volume_size_kb
NUMBER
Used volume size in KiB
vm_host_id
NUMBER
Foreign key to VM server details
vm_host_name
STRING
VM server name
vm_id
NUMBER
Foreign key to VM details
vm_name
STRING
VM name
vm_size_gb
NUMBER
VM size in GiB
vm_size_kb
NUMBER
VM size in KiB
apt_v_vio_partition
IBM Virtualization is based on the logical partitioning (LPAR). Each server can be divided in logical partitions. Each VIO Server can be divided in logical partitions.
Table 4.294 apt_v_vio_partition
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
apt_v_vio_scsi_adapter
IBM VIO Server software allows the virtual SCSI adapters and virtual Ethernet adapters to be created and they can be assigned to each LPAR at the creation of them. SCSI Adapters can be assigned to each LPAR.
Table 4.295 apt_v_vio_scsi_adapter
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
apt_v_vio_server
IBM VIO Server software is a modified AIX operating system on Power5 Series and can support the Linux and AIX client.
Table 4.296 apt_v_vio_server
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
apt_v_vio_target_device
Target disks or backing devices connect to the VIO Servers.
Table 4.297 apt_v_vio_target_device
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
apt_v_vio_virtual_system
The Virtual I/O Server (VIOS) provides virtual SCSI target and Shared Ethernet Adapter (SEA) virtual I/O function to client logical partitions. Virtual I/O Server (VIOS) is part of the Advanced POWER Virtualization hardware feature on IBM System P5.
Table 4.298 apt_v_vio_virtual_system
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