SYSPARTITIONINDEXDISK

The SYSPARTITIONINDEXDISK view contains one row for every disk unit used to store the index data of every table partition or table member. If the index is a distributed index, 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 SYSPARTITIONINDEXDISK view:

Table 1. SYSPARTITIONINDEXDISK 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.
PARTITION_TYPE	PARTTYPE	CHAR(1)	The type of the table partitioning: blank The table is not partitioned. H This is data hash partitioning. R This is data range partitioning. D This is distributed database hash partitioning.
PARTITION_NUMBER	PARTNBR	INTEGER Nullable	The partition number of this partition. If the table is a distributed table, contains null.
NUMBER_DISTRIBUTED_PARTITIONS	DSTPARTS	INTEGER Nullable	If the table is a distributed table, contains the total number of partitions. If the table is not a distributed table, contains null.
INDEX_SCHEMA	INDSCHEMA	VARCHAR(128)	Name of the SQL schema that contains the index, logical file, or constraint.
INDEX_NAME	INDNAME	VARCHAR(128)	Name of the index, logical file, or constraint.
INDEX_MEMBER	INDMEMBER	VARCHAR(128) Nullable	Name of the member of the index or logical file. If the index type is a constraint, the member name is null.
INDEX_TYPE	INDTYPE	VARCHAR(11)	The type of the index: INDEX The index is an SQL index. LOGICAL The index is part of a logical file. PHYSICAL The index is part of a keyed physical file. PRIMARY KEY The index is a primary key constraint. UNIQUE The index is a unique constraint. REFERENTIAL The index is a foreign key constraint.
ASP_NUMBER	ASP_NUMBER	SMALLINT	Auxiliary Storage Pool (ASP) containing the index.
DISK_TYPE	DISK_TYPE	CHAR(4)	Disk type number of the disk.
DISK_MODEL	DISK_MODEL	CHAR(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 index.
UNIT_TYPE	UNIT_TYPE	SMALLINT	Indicates the type of disk unit: 0 Not Solid State Disk (SSD). 1 Solid State Disk (SSD).
SYSTEM_INDEX_SCHEMA	SYS_IXDNAME	CHAR(10)	System index schema name.
SYSTEM_INDEX_NAME	SYS_IXNAME	CHAR(10)	System index name.
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.