Capacity Manager Database Views > IBM Storage Array Database Views
  
Version 10.0.00
IBM Storage Array Database Views
aps_v_ibm_array
The aps_v_ibm_array view contains a single row for each IBM 6K/8K storage array.
Table 4.257 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
aps_v_ibm_ckd_volume
The aps_v_ibm_ckd_volume view contains a single row for each CKD volume in an IBM 6K/8K storage array.
Table 4.258 aps_v_ibm_ckd_volume
Column Name
Data Type
Description
access_state
STRING
Online - The logical volume is accessible to a host.
Fenced - The logical volume is in the volume fenced state and is not accessible to the host.
addrgrp_id
STRING
Storage image address group unique identifier
alloc_repo_capacity
STRING
allocated physical repository capacity of the track space-efficient storage
This value is calculated on the available repository capacity as a result of writes to the space-efficient volume. This value is displayed in the format of X.Y, where X is whole GB (1GB=2^30B) and Y represents tenths of a GB, which is limited to a single digit (0 - 9). Note: A null (-) value is displayed in this column if the value displayed in the SAM column is Standard.
ckd_org_base_volume
STRING
Identifies the original base CKD volume ID to which this CKD alias volume is assigned.
For a CKD Alias type volume, the base and alias volume IDs share a common LCU ID.
- (null) is displayed for a CKD base volume type.
ckd_serial_nbr
STRING
Volume serial number
ckd_vol_type
STRING
Logical volume is one of the following: CKD base, CKD alias
config_state
STRING
Normal - Indicates that there are no logical volume configuration operations in progress.
Configuring - Indicates that the logical volume is in the process of being configured for the first time.
Reconfiguring - Indicates that the logical volume is in the process of allocating or deallocating extents due to a modification of the requested capacity attribute after initial creation.
Migrating - Indicates that the logical volume is in the process of performing dynamic volume relocation to a specified extent pool.
Deconfiguring - Indicates that the logical volume is in the process of being deleted.
Configuration error - Indicates that the initial configuration did not complete successfully. This state reflects an internal error condition and not an error in the request to create the volume. Corrective action: Use the rmfbvol command to delete each volume listed with the configuration state of configuration error.
Reconfiguration error - Indicates that the reconfiguration request did not complete successfully.
Migration error - Indicates that the dynamic volume relocation operation was ended during processing.
Deconfiguration error - Indicates that a request to delete a volume did not complete successfully. This state reflects an internal error condition and not an error in the request to remove the volume. To correct this state, you must reissue the rmfbvol command for the designated volume.
data_state
STRING
Normal - None of the other data states apply. The access state is Online.
Pinned - Specifies that none of the other data states apply and the logical volume has one or more pinned non-retryable tracks. The access state is Online.
Read only - Indicates that the logical volume can be read but not written to because one or more extents on the logical volume are on a rank in the read only data state. The access state is Online.
Inaccessible - Indicates that one or more extents that are associated with the logical volume are on a rank that is in the inaccessible data state. The access state is Fenced.
Virtual space fault - Specifies that the logical volume has a storage allocation method of extent space-efficient or track space-efficient. There was not enough available space to convert a virtual logical track to a real logical track. The access state is Online.
Indeterminate data loss - Specifies that the following data states do not apply and that one of the following conditions has occurred: Data states that do not apply: Rank failed, Rank repairing, Rank repaired, Global inaccessible, Global lost data
NVS data inaccessible - Specifies that active nonvolatile storage (NVS) data is inaccessible for one or more logical volumes of an LSS group. The logical volumes in the LSS group cannot be made accessible. The access state is Fenced.
data_type
STRING
Volume data type setting. One of the following values is displayed: FB 512, FB 520P, FB 520U
device_mtm
STRING
Volume device type and the machine type. The volume MTM is determined by the fixed block volume data type and the volume capacity (in GB). The machine type is either 2107 or 1750; however, the MTM can be any one of the following depending on your system: 2107-900 This indicates a standard 2107 volume. 1750-500 This indicates a standard 1750 volume. xxxx-A0x The xxxx is 2107 or 1750; the A0 indicates a System i protected volume (for example, 2107-A01 or 1750-A07). xxxx-A8x The xxxx is 2107 or 1750; the A8 indicates a System i unprotected volume (for example, 2107-A81 or 1750-A87).
eam
STRING
Extent allocation method that was used when the logical volume was created. One of the following values is displayed:
legacy - Designates that the volume was created before the use of the current algorithm. Legacy is always the reported value for a DS6000 model.
rotateexts - Designates that volumes were created using storage-pool striping. rotatevols Designates that each successive logical volume that is created is allocated on the next available rank in the extent pool.
A null (-) value is displayed if the extent allocation method does not apply because the specified volume is a space-efficient volume.
extpool_name
STRING
name assigned to the extent pool
ibm_address_group_id
NUMBER
Foreign key to address group details
ibm_extent_pool_id
NUMBER
Foreign key to extent pool details
ibm_logical_volume_id
NUMBER
Foreign key to logical volume details
ibm_storage_system_id
NUMBER
Foreign key to IBM storage system details
last_updated
DATE
last updated date
logvol_id
STRING
Unique identifier that is assigned to this volume object
logvol_name
STRING
Logical volume name
nbr_of_extent
NUMBER
Number of extents used by the designated volume ID
nbr_of_rank
NUMBER
Number of ranks that the volume resides on
request_capacity
NUMBER
Requested quantity of volume logical in KiB
SAM
STRING
storage allocation method
standard - Designates that the system fully allocated the volume with real extents at volume creation time. An inquiry on a DS6000 model always reports this value.
tse - Designates that a track space-efficient logical volume contains a set of virtual extents that are associated with the space-efficient storage in the same extent pool. Physical space for a given logical track on a track space-efficient logical volume is dynamically allocated and deallocated from the repository in the space-efficient storage.
system_name
STRING
name assigned to the storage unit
vol_capacity_gb
NUMBER
Logical Volume Capacity in GiB
vol_capacity_kb
NUMBER
Logical Volume Capacity in KiB
aps_v_ibm_disk
The aps_v_ibm_disk view contains a single row for each disk in an IBM 6K/8K storage array.
Table 4.259 aps_v_ibm_disk
Column Name
Data Type
Description
arsite_id
STRING
Array site ID
da_pair
STRING
Device adapter pair ID that is associated with the specified device adapter
disk_capacity_gb
NUMBER
DDM raw capacity in GiB
disk_capacity_kb
NUMBER
DDM raw capacity in KiB
disk_class
STRING
Disk class is either high speed fibre-channel disk drives or near-line disk drives.
The displayed value is one of the following:
ENT - Specifies enterprise and represents high speed fibre-channel disk drives
NL - Specifies near-line and represents ATA (FATA) disk drives
disk_id
STRING
System-assigned unique identifier for the DDM
disk_interface_rate
NUMBER
DDM interface rate
disk_interface_type
STRING
DDM interface type. One of the following values are displayed: FC-AL, FC-NL
disk_rpm
NUMBER
DDM rpm
disk_usage
STRING
DDM usage in an array site. One of the following values are displayed:
unassigned, unconfigured, spare required,
spare not required, array member
dual_loop
NUMBER
Dual loop that the specified DDM resides on. The value is either 1 or 2
firmware_level
STRING
Level of firmware that is installed on the specified DDM
ibm_array_site_id
NUMBER
Foreign key to array site details
ibm_device_adapter_id
NUMBER
Foreign key to device adapter details
ibm_physical_disk_id
NUMBER
Foreign key to physical disk details
ibm_storage_system_id
NUMBER
Foreign key to IBM storage system details
last_updated
DATE
last updated date
location
STRING
Storage enclosure and the DDM location. The DDM location format is Pn-Dn, where Pn is the Planer number (1), and Dn is the DDM number (1 - 16)
model
STRING
DDM model. The model name is a string of the form VRFCGGG, where VRFC is the type of disk family and GGG is the disk capacity in GB.
position
NUMBER
DDM position in an array site configuration of DDMs
state
STRING
Current DDM state.
One of the following values are displayed:
Normal - The storage device is operational and functional in its current disk usage.
New Indicates the initial state when a DDM is inserted or first discovered.
Installing A new storage device has been identified.
Verifying - The storage device is made accessible to the device adapter, its characteristics are determined, cabling is checked, and diagnostics are run.
Formatting - A verified storage device requires low-level formatting and the formatting operation is in progress.
Initializing The storage device is being initialized with all zero sectors.
Certifying -The storage device is read-accessed to determine that all sectors can be read.
Rebuilding - The storage device is being rebuilt with data from the array that it is associated with.
Migration - Target DDM migration is migrating another array member storage device to this spare storage device.
Migration Source DDM migration is migrating this array member storage device to another spare storage device.
Failed - The storage device has failed and an immediate repair action is required.
Failed - Deferred Service - The storage device has failed and a repair action is not immediately required.
Removed - The storage device is removed from the system and removal has been processed by the system.
Inappropriate -The storage device is incompatible with the system; for example, a storage device that has the wrong capacity or rpm. The DDM is not failed, because it can be valid for other systems and locations.
Inter failed - Indicates that the DDM is faulty but still working.
PFSed - Indicates that the DDM is prepared for service, and ready to be removed without impacting the system
system_name
STRING
name assigned to the storage unit
aps_v_ibm_extent_pool
The aps_v_ibm_extent_pool view contains a single row for each IBM extent pool.
Table 4.260 aps_v_ibm_extent_pool
Column Name
Data Type
Description
available_capacity_kb
NUMBER
Available capacity in KiB
ext_pool_status
STRING
Extent pool status
extent_allocated
NUMBER
Allocated Extents
extent_allocated_pct
NUMBER
Allocated Extent %
extent_allowed
NUMBER
Allowed Extent
extent_available
NUMBER
Available Extents
extent_available_pct
NUMBER
Available Extents %
extent_configured
NUMBER
Configured Extents
extent_limit_pct
NUMBER
Extent Limit %
extent_reserved
NUMBER
Reserved extent
extent_threshold_pct
NUMBER
Extent threshold %
extpool_id
STRING
Extent Pool ID
extpool_name
STRING
Extent pool name
ibm_extent_pool_id
NUMBER
Foreign key to extent pool details
ibm_storage_system_id
NUMBER
Foreign key to IBM storage system details
last_updated
DATE
Date and time the IBM extent pool data was last updated in the StorageConsole database.
nbr_of_rank
NUMBER
Number of ranks
nbr_of_volume
NUMBER
Number of volumes
rank_group
NUMBER
Rank group
reserved_capacity_kb
NUMBER
Reserved Capacity in KiB
storage_type
STRING
Storage type
total_capacity_kb
NUMBER
Total capacity in KiB
virtual_extent_allocated
NUMBER
Allocated virtual extents
virtual_extent_allocated_pct
NUMBER
Allocated virtual extents percentage
virtual_extent_allowed
NUMBER
Allowed virtual extents
virtual_extent_available
NUMBER
Virtual extents available
virtual_extent_available_pct
NUMBER
Virtual extents available %
virtual_extent_configured
NUMBER
Virtual extents configured
virtual_extent_limit_pct
NUMBER
Virtual extents limit %
virtual_extent_reserved
NUMBER
Reserved virtual extents
virtual_extent_threshold_pct
NUMBER
Virtual extents threshold %
virtual_status
STRING
Virtual status
aps_v_ibm_fb_volume
The aps_v_ibm_fb_volume view contains a single row for each fixed block volume of IBM 6K/8K storage.
Table 4.261 aps_v_ibm_fb_volume
Column Name
Data Type
Description
access_state
STRING
Online - The logical volume is accessible to a host.
Fenced -The logical volume is in the volume fenced state and is not accessible to the host.
addrgrp_id
STRING
Storage image address group unique identifier
alloc_repo_capacity
STRING
allocated physical repository capacity of the track space-efficient storage.
This value is calculated on the available repository capacity as a result of writes to the space-efficient volume. This value is displayed in the format of X.Y, where X is whole GB (1GB=2^30B) and Y represents tenths of a GB, which is limited to a single digit (0 - 9).Note: A null (-) value is displayed in this column if the value displayed in the SAM column is Standard.
config_state
STRING
Normal - Indicates that there are no logical volume configuration operations in progress.
Configuring - Indicates that the logical volume is in the process of being configured for the first time.
Reconfiguring - Indicates that the logical volume is in the process of allocating or deallocating extents due to a modification of the requested capacity attribute after initial creation.
Migrating - Indicates that the logical volume is in the process of performing dynamic volume relocation to a specified extent pool.
Deconfiguring - Indicates that the logical volume is in the process of being deleted.
Configuration error - Indicates that the initial configuration did not complete successfully. This state reflects an internal error condition and not an error in the request to create the volume. Corrective action: Use the rmfbvol command to delete each volume listed with the configuration state of ?configuration error?.
Reconfiguration error - Indicates that the reconfiguration request did not complete successfully.
Migration error - Indicates that the dynamic volume relocation operation was ended during processing.
Deconfiguration error - Indicates that a request to delete a volume did not complete successfully. This state reflects an internal error condition and not an error in the request to remove the volume. To correct this state, you must reissue the rmfbvol command for the designated volume.
data_state
STRING
Normal - None of the other data states apply. The access state is Online.
Pinned - Specifies that none of the other data states apply and the logical volume has one or more pinned non-retryable tracks. The access state is Online.
Read only - Indicates that the logical volume can be read but not written to because one or more extents on the logical volume are on a rank in the read only data state. The access state is Online.
Inaccessible - Indicates that one or more extents that are associated with the logical volume are on a rank that is in the inaccessible data state. The access state is Fenced.
Virtual space fault - Specifies that the logical volume has a storage allocation method of extent space-efficient or track space-efficient. There was not enough available space to convert a virtual logical track to a real logical track. The access state is Online.
Indeterminate data loss - Specifies that the following data states do not apply and that one of the following conditions has occurred: Data states that do not apply: Rank failed, Rank repairing, Rank repaired, Global inaccessible, Global lost dataConditions
NVS data inaccessible - Specifies that active nonvolatile storage (NVS) data is inaccessible for one or more logical volumes of an LSS group. The logical volumes in the LSS group cannot be made accessible. The access state is Fenced.
data_type
STRING
Volume data type setting. One of the following values is displayed: FB 512, FB 520P, FB 520U
device_mtm
STRING
Volume device type and the machine type. The volume MTM is determined by the fixed block volume data type and the volume capacity (in GB). The machine type is either 2107 or 1750; however, the MTM can be any one of the following depending on your system: 2107-900 This indicates a standard 2107 volume. 1750-500 This indicates a standard 1750 volume. xxxx-A0x The xxxx is 2107 or 1750; the A0 indicates a System i protected volume (for example, 2107-A01 or 1750-A07). xxxx-A8x The xxxx is 2107 or 1750; the A8 indicates a System i unprotected volume (for example, 2107-A81 or 1750-A87).
eam
STRING
Extent allocation method that was used when the logical volume was created.
legacy - Designates that the volume was created before the use of the current algorithm. Legacy is always the reported value for a DS6000 model.
rotateexts - Designates that volumes were created using storage-pool striping. rotatevols Designates that each successive logical volume that is created is allocated on the next available rank in the extent pool.
A null (-) value is displayed if the extent allocation method does not apply because the specified volume is a space-efficient volume.
extpool_name
STRING
name assigned to the extent pool
fb_capacity_type
STRING
Capacity unit type used at volume creation. One of the following values is displayed:
ESS - The capacity unit is 10 ^ 9B.
DS - The capacity unit is 2 ^ 30B.
DS/ESS - The capacity unit is 2 ^ 30B or 10 ^ 9B.
Blocks - The capacity unit 512B.iSeries The capacity unit was not specified at volume creation. This fixed block volume was created for iSeries.
fb_lun_nbr
NUMBER
Corresponding LUN number for the volume seen by the host
ibm_address_group_id
NUMBER
Foreign key to address group details
ibm_extent_pool_id
NUMBER
Foreign key to extent pool details
ibm_logical_volume_id
NUMBER
Foreign key to logical volume details
ibm_storage_system_id
NUMBER
Foreign key to IBM storage system details
last_updated
DATE
last updated date
logvol_id
STRING
Unique identifier that is assigned to this volume object
logvol_name
STRING
Logical volume name
nbr_of_extent
NUMBER
Number of extents used by the designated volume ID
nbr_of_rank
NUMBER
Number of ranks that the volume resides on
request_capacity
NUMBER
Requested quantity of volume logical in KiB
sam
STRING
storage allocation method
standard - Designates that the system fully allocated the volume with real extents at volume creation time. An inquiry on a DS6000 model always reports this value.
tse- Designates that a track space-efficient logical volume contains a set of virtual extents that are associated with the space-efficient storage in the same extent pool. Physical space for a given logical track on a track space-efficient logical volume is dynamically allocated and deallocated from the repository in the space-efficient storage.
system_name
STRING
name assigned to the storage unit
vol_capacity_gb
NUMBER
Logical Volume Capacity in GiB
vol_capacity_kb
NUMBER
Logical Volume Capacity in KiB
aps_v_ibm_rank
The aps_v_ibm_rank view contains a single row for each IBM rank.
Table 4.262 aps_v_ibm_rank
Column Name
Data Type
Description
available_capacity_kb
NUMBER
Available capacity
byte_read
NUMBER
Read Bytes
byte_write
NUMBER
Write Bytes
counter_timestamp
STRING
Counter Timestamp
data_state
STRING
Normal = None of the other data states apply. The access state is Online.
Pinned = None of the other data states apply and the logical volume has one or more pinned non-retryable tracks. Access state is Online.
Read only = Logical volume can be read but not written to; extents on the logical volume are on a rank in a read-only state. Access state is Online.
Inaccessible = Extents associated with the logical volume are on a rank that is in an inaccessible state. Access state is Fenced.
Virtual space fault = Logical volume has a storage allocation method of extent space-efficient or track space-efficient. No available space to convert a virtual logical track to a real logical track. Access state is Online.
Indeterminate data loss = Data states that do not apply: Rank failed, Rank repairing, Rank repaired, Global inaccessible, Global lost. One of the following conditions has occurred:
- Committed write was lost before destaged; track IDs associated with data unknown.
- Data lost, indicating extents on the logical volume were active FlashCopy targets. Access state is Fenced.
Rank failed = Extents associated with the logical volume are on a rank that is in the Failed state. Access state is Fenced. State could change to Rank repairing.
Rank Repairing = One or more extents that are associated with the logical volume are on ranks in the repairing data state. The access state is Fenced.
Rank Repaired = Extents associated with logical volume were on ranks finished repairing. Access state is Fenced.
Global inaccessible = Global metadata associated with the logical volume is inaccessible. Some data might be inaccurate. Access state is Fenced.
Global lost = Global metadata associated with the logical volume has been lost. Some data might be inaccurate. Access state is Fenced.
NVS data inaccessible = Active nonvolatile storage (NVS) data is inaccessible for one or more logical volumes of an LSS group. Logical volumes in the LSS group cannot be made accessible. Access state is Fenced.
extent_size_trk
NUMBER
Extent size
ibm_array_id
NUMBER
Foreign key to array details
ibm_extent_pool_id
NUMBER
Foreign key to extent pool details
ibm_rank_id
NUMBER
Unique identifier for IBM Rank
ibm_storage_system
NUMBER
Foreign key to IBM storage system details
last_updated
DATE
Date and time the IBM rank data was last updated in the StorageConsole database.
nbr_of_array_sites
NUMBER
Number of array sites
nbr_of_extent
NUMBER
Number of extents
nbr_of_narrow_array
NUMBER
Number of narrow arrays
raid_type
STRING
RAID type
rank_group
NUMBER
Rank Group
rank_id
STRING
Rank Identifier
reads
NUMBER
Number of Reads
serial_nbr
STRING
Serial Number
state
STRING
State
storage_type
STRING
Storage type
system_name
STRING
System name
time_read
NUMBER
Time taken for read
time_write
NUMBER
Time taken for write
total_capacity_kb
NUMBER
Total capacity
track_size
NUMBER
Track size
used_capacity_kb
NUMBER
Used capacity
used_extent
NUMBER
Used Extent
writes
NUMBER
Number of Writes
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.263 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
aps_v_ibm_storage_system
The aps_v_ibm_storage_system view contains a single row for each IBM 6K/8K storage array.
Table 4.264 aps_v_ibm_storage_system
Column Name
Data Type
Description
cache_memory_gb
NUMBER
Cache memory configured on the storage unit in GiB
config_allocated_gb
NUMBER
Allocated configured Capacity in GiB
config_allocated_kb
NUMBER
Allocated configured Capacity in KiB
config_available_gb
NUMBER
Configured capacity free in GiB
config_available_kb
NUMBER
Configured capacity free in KiB
config_capacity_gb
NUMBER
Total Configured Capacity in GiB
config_capacity_kb
NUMBER
Total Configured Capacity in KiB
description
STRING
value assigned as a description for the storage unit
device_manager_id
NUMBER
Foreign key to device manager details
domain_id
NUMBER
Foreign key to domain details
domain_name
STRING
Domain name
ds_cli_version
STRING
DS CLI version
ibm_storage_system_id
NUMBER
Foreign key to IBM storage system details
is_active
STRING
Y=Yes, N=No
is_essnet
STRING
Y=Yes, N=No, the storage-complex ESSNet user interface can invoke Copy Services operations to this storage image
last_updated
DATE
last updated date
model
STRING
model number that is associated with the storage unit
mts
STRING
order type of the storage unit
nbr_allocated_luns
NUMBER
Number of allocated logical units
nbr_of_luns
NUMBER
Number of logical units
node_wwn_id
STRING
Foreign key to WWN
nvs_memory_gb
NUMBER
Nonvolatile storage (NVS) memory configured on the storage unit in gigabytes
os400_serial_nbr
STRING
Null (-) for a DS8000 model and the iSeries serial number for a DS6000 model
processor_memory_gb
NUMBER
Processor memory configured on the storage unit in GiB
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
Raw capacity in GiB
raw_capacity_kb
NUMBER
Raw capacity in KiB
signature
STRING
machine signature that is represented by 12 hexadecimal digits in the format xxxx-xxxx-xxxx
state
STRING
state of the storage unit:
online, offline, resuming, quiescing, quiesce exception, forced quiescing, fenced, discovery
storage_manager_version
STRING
Storage Manager Version
system_family
STRING
System family
system_id
STRING
storage image ID that consists of the manufacture, machine type, and serial number
system_name
STRING
name assigned to the storage unit
system_type
STRING
System type
wwn
STRING
worldwide node name that is assigned to the storage unit
aps_v_ibm_subsys_array
The aps_v_ibm_subsys_array view contains a single row for each IBM 3K/4K storage array.
Table 4.265 aps_v_ibm_subsys_array
Column Name
Data Type
Description
array_name
STRING
name of the array
array_status
STRING
status of the array
available_size_gb
NUMBER
Available capacity of the Array in GiB
available_size_kb
NUMBER
Available capacity of the Array in KiB
ibms_array_id
NUMBER
Foreign key to array details
ibms_storage_subsystem_id
NUMBER
Foreign key to IBM storage subsystem details
last_updated
DATE
last updated date
raid_level
NUMBER
RAID level of the array
system_name
STRING
System name
total_size_gb
NUMBER
Total capacity of the Array in GiB
total_size_kb
NUMBER
Total capacity of the Array in KiB
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.266 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
aps_v_ibm_subsys_logical_drive
The aps_v_ibm_subsys_logical_drive view contains a single row for each logical drive in an IBM 3K/4K storage array.
Table 4.267 aps_v_ibm_subsys_logical_drive
Column Name
Data Type
Description
array_name
STRING
Name of the array
current_owner
STRING
Current owner of the logical drive
drive_type
STRING
Drive type
ibms_array_ID
NUMBER
Foreign key to array details
ibms_logical_drive_id
NUMBER
Foreign key to logical drive details
ibms_storage_subsystem_id
NUMBER
Foreign key to IBM storage subsystem details
is_encl_loss_protection
STRING
Y=Yes, N=No
last_updated
DATE
last updated date
ldrive_id
STRING
Logical Drive world-wide identifier
logical_drive_name
STRING
Logical drive name
logical_drive_statue
STRING
Logical drive status
prefer_owner
STRING
Preferred owner
raid_level
NUMBER
RAID level
segment_size_gb
NUMBER
segment size in GiB
segment_size_kb
NUMBER
segment size in KiB
size_gb
NUMBER
Total capacity of the logical drive in GiB
size_kb
NUMBER
Total capacity of the logical drive in KiB
ssid
NUMBER
Subsystem ID
system_name
STRING
System name