Storage Viewer for Capacity Database Views > aps_v_ibm_subsys_disk
  
Version 10.0.01
aps_v_ibm_subsys_disk
The aps_v_ibm_subsys_disk view contains a single row for each disk in an IBM 3K/4K storage array.
Table 4.271 aps_v_ibm_subsys_disk
Column Name
Data Type
Description
array_name
STRING
name of the array
cur_data_rate
NUMBER
Current data rate of the disk
disk_id
STRING
World-wide identifier
disk_mode
STRING
Indicates whether the disk is assigned or not
disk_slot
NUMBER
Disk slot
disk_speed
NUMBER
RPM of the disk
disk_status
STRING
Status of the disk
drive_type
STRING
Drive type of the disk
enclosure
NUMBER
Enclosure where the drive resides
firmware_version
STRING
Firmware version
ibms_array_id
NUMBER
Foreign key to array details
ibms_physical_disk_id
NUMBER
Foreign key to physical disk details
ibms_storage_subsystem_id
NUMBER
Foreign key to IBM storage subsystem details
last_updated
DATE
last updated date
product_id
STRING
Product ID
raw_capacity_gb
NUMBER
Raw capacity in GiB
raw_capacity_kb
NUMBER
Raw capacity in KiB
serial_nbr
STRING
Serial number
system_name
STRING
System name
usable_capacity_gb
NUMBER
Usable capacity in GiB
usable_capacity_kb
NUMBER
Usable capacity in KiB
vendor
STRING
Disk vendor