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

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

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

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

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

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

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

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

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

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

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

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