Storage Viewer for Capacity Database Views > aps_v_ibm_storage_subsystem
  
Version 10.0.01
aps_v_ibm_storage_subsystem
The aps_v_ibm_storage_subsystem view contains a single row for each subsystem of an IBM 3K/4K storage array.
Table 4.268 aps_v_ibm_storage_subsystem
Column Name
Data Type
Description
cache_memory_gb
NUMBER
Cache Memory in GiB
cache_memory_kb
NUMBER
Cache Memory in KiB
config_allocated_gb
NUMBER
Allocated configured capacity in GiB
config_allocated_kb
NUMBER
Allocated configured capacity in KiB
config_available_gb
NUMBER
Available configured capacity in GiB
config_available_kb
NUMBER
Available configured capacity in KiB
config_capacity_gb
NUMBER
Total configured capacity in GiB
config_capacity_kb
NUMBER
Total configured capacity in KiB
device_manager_id
NUMBER
Foreign key to device manager details
domain_id
NUMBER
Foreign key to domain details
domain_name
STRING
Domain name
firmware_version
STRING
Firmware version
ibms_storage_subsystem_id
NUMBER
Foreign key to IBM storage subsystem details
is_active
STRING
Y=Yes, N=No
last_updated
DATE
last updated date
model
STRING
Model
nbr_allocated_luns
NUMBER
Number of allocated logical drives
nbr_of_controller
NUMBER
Number of controllers
nbr_of_drive
NUMBER
Number of drives
nbr_of_logical_drive
NUMBER
Number of logical drives
nbr_of_logical_drive_group
NUMBER
Number of logical drive groups
nvsram_version
STRING
NVSRAM version
product_name
STRING
Product name
raw_allocated_gb
NUMBER
Allocated raw capacity in GiB
raw_allocated_kb
NUMBER
Allocated raw capacity in KiB
raw_available_gb
NUMBER
Available raw capacity in GiB
raw_available_kb
NUMBER
Available raw capacity in KiB
raw_capacity_gb
NUMBER
Total raw capacity in GiB
raw_capacity_kb
NUMBER
Total raw capacity in KiB
system_family
STRING
System family
system_id
STRING
Storage Subsystem world-wide identifier (ID)
system_name
STRING
System name
system_type
STRING
System type