SYSPARTITIONDISK

The SYSPARTITIONDISK view contains one row for every disk unit used to store data of every table partition or table member. If the table is a distributed table, the partitions that reside on other database nodes are not contained in this catalog view. They are contained in the catalog views of the other database nodes.

The following table describes the columns in the SYSPARTITIONDISK view:

Table 1. SYSPARTITIONDISK view
Column name System Column Name Data Type Description
TABLE_SCHEMA TABSCHEMA VARCHAR(128) Name of the SQL schema that contains the table.
TABLE_NAME TABNAME VARCHAR(128) Name of the table.
TABLE_PARTITION TABPART VARCHAR(128) Name of the table partition or member.
ASP_NUMBER ASP_NUMBER SMALLINT Auxiliary Storage Pool (ASP) containing the partition.
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.
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.
UNIT_MEDIA_CAPACITY UNITMCAP BIGINT Storage capacity (in bytes) of the unit.
UNIT_SPACE_AVAILABLE UNITSPACE BIGINT Space (in bytes) available on the unit for use.
UNIT_SPACE_RESERVED_FOR_SYSTEM UNITSRES BIGINT Space (in bytes) reserved on the unit for use by the system.
UNIT_SPACE_USED UNITSUSED BIGINT Space (in bytes) on the unit used for the partition.
UNIT_TOTAL_ACCESS_TIME UNITTATIME INTEGER The estimated time, in milliseconds, required to sequentially read the fixed-length data on the unit for the partition. The time is based on the amount of data on the unit and the average access time of the unit. The estimate assumes there will be no contention with other threads for the disk.
UNIT_TYPE UNIT_TYPE SMALLINT Indicates the type of disk unit:
0
Not Solid State Disk (SSD).
1
Solid State Disk (SSD).
DATA_SEGMENT_TYPE SEGMENT SMALLINT Segment type of the disk.
0
Indicates that this segment is for fixed-length data.
1
Indicates that this segment is for variable-length data.
SYSTEM_TABLE_SCHEMA SYS_DNAME CHAR(10) System schema name.
SYSTEM_TABLE_NAME SYS_TNAME CHAR(10) System table name.
SYSTEM_TABLE_MEMBER SYS_MNAME CHAR(10) System member name.