SYSDISKSTAT view

The SYSDISKSTAT view contains information about disks.

The following table describes the columns in the view. The schema is QSYS2.

Table 1. SYSDISKSTAT view
Column Name System Column Name Data Type Description
ASP_NUMBER ASP_NUMBER SMALLINT Specifies the independent auxiliary storage pool (IASP) number.
DISK_TYPE DISK_TYPE VARCHAR(4) Disk type number of the disk.
DISK_MODEL DISK_MODEL VARCHAR(4) Model number of the disk.
UNIT_NUMBER UNITNBR SMALLINT Unit number of the disk.
UNIT_TYPE UNIT_TYPE SMALLINT Indicates the type of disk unit:
0
Not solid state disk
1
Solid state disk (SSD)
UNIT_STORAGE_CAPACITY UNITSCAP BIGINT Unit storage capacity has the same value as the unit media capacity for configured disk units. This value is 0 for non-configured units.
UNIT_SPACE_AVAILABLE UNITSPACE BIGINT Space (in bytes) available on the unit for use.
PERCENT_USED PERCENTUSE
DECIMAL(7,3)
Nullable
 The percentage that the disk unit has been consumed.
UNIT_MEDIA_CAPACITY UNITMCAP BIGINT Storage capacity (in bytes) of the unit.
LOGICAL_MIRRORED_PAIR_STATUS MIRRORPS
CHAR(1)
Nullable
 Indicates the status of a mirrored pair of disks:
0
Indicates that one mirrored unit of a mirrored pair is not active.
1
Indicates that both mirrored units of a mirrored pair are active.
Contains null if the unit is not mirrored.
MIRRORED_UNIT_STATUS MIRRORUS
CHAR(1)
Nullable
 Indicates the status of a mirrored unit:
1
Indicates that this mirrored unit of a mirrored pair is active (online with current data).
2
Indicates that this mirrored unit is being synchronized.
3
Indicates that this mirrored unit is suspended.
Contains null if the unit is not mirrored.

Example

  • Return information about all disks.

    SELECT * FROM QSYS2.SYSDISKSTAT

  • Return information for all SSD units.

    SELECT * FROM QSYS2.SYSDISKSTAT WHERE UNIT_TYPE = 1