Storage Viewer for Capacity Database Views > aps_v_ibm_array
  
Version 10.0.01
aps_v_ibm_array
The aps_v_ibm_array view contains a single row for each IBM 6K/8K storage array.
Table 4.262 aps_v_ibm_array
Column Name
Data Type
Description
array_id
STRING
Array ID
arsite_id
STRING
Array site ID
da_pair
STRING
Device adapter pair ID that is associated with the specified device adapter
data_state
STRING
Current data state
Normal - The array is in the Normal data state if none of the other data states applies. This status applies if the array is unassigned.
Degraded - The array is in the Degraded data state if both of the following conditions exist: The Read-only, Failed, Repairing, or Inaccessible data states do not apply.One or more redundancy groups are rebuilding (that is, there is a DDM with a rebuilding state in the array).
ddm_capacity_gb
NUMBER
Minimum disk capacity (10^9B) of the storage devices (DDMs) in the designated array in gigabytes
ddm_capacity_kb
NUMBER
Minimum disk capacity (10^9B) of the storage devices (DDMs) in the designated array in kilobytes
ddm_rpm
NUMBER
Minimum disk rpm of the DDMs in the designated array
disk_class
STRING
Disk class is either high speed fibre-channel disk drives or near-line disk drives
ENT - Specifies enterprise and represents high speed fibre-channel disk drives
NL - Specifies near-line and represents ATA (FATA) disk drives
disk_interface_rate
NUMBER
Minimum disk interface rate of the disks in the designated array
disk_interface_type
STRING
Disk interface type of the DDMs in the designated array
ibm_array_id
NUMBER
Foreign key to array details
ibm_array_site_id
NUMBER
Foreign key to array site details
ibm_device_adapter_id
NUMBER
Foreign key to device adapter details
ibm_storage_system_id
NUMBER
Foreign key to IBM storage system details
last_update
DATE
last updated date
raid_type
STRING
Type of RAID array (5 or 10) and the array configuration (for example, 6+P)
serial_nbr
STRING
Unique internal identifier for the data space of the designated array
state
STRING
Assigned - The array is assigned to a rank.
Unassigned - The array is not assigned to a rank and all of the storage devices that are indicated by the disk serial numbers attribute are in the normal state.
Unavailable - The array is not assigned to a rank and one or more of the disk drive modules (DDMs) that are indicated by the disk serial numbers attribute are not in the normal state.
Read Only -The array is in the Read-only data state if all of the following conditions exist: The Failed, Repairing, and Inaccessible data states do not apply. One or more DDMs have failed. There are insufficient spares to support all rebuild operations. Continued write operation without redundancy could result in data loss.
Failed - The array is in the Failed data state if all of the following conditions exist: The Repairing and Inaccessible data states do not apply. Two or more DDMs in the array have failed. There are insufficient DDMs left in the array to rebuild the data that was lost on the failing storage devices.
Repairing - The array is in the Repairing data state if all of the following conditions exist: The Inaccessible data state does not apply. The array has previously entered the failed state. The repair array function has been accepted. The repair array function has not completed.
Inaccessible - The array is in the Inaccessible data state if the storage unit cannot access a set of storage devices that are sufficient to access all the data on the array.
system_name
STRING
name assigned to the storage unit