The HSSYSIND table is used for SYSINDEXES views. The following table describes the columns in the HSSYSIND table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| NAME | VARCHAR | 128 | 0 | Name of the index |
| CREATOR | VARCHAR | 128 | 0 | The schema of the index |
| TBNAME | VARCHAR | 128 | 0 | Name of the table on which the index is defined |
| TBCREATOR | VARCHAR | 128 | 0 | The schema of the table |
| UNIQUERULE | CHAR | 1 | 0 | Whether the index is unique |
| COLCOUNT | SMALLINT | 4 | 0 | The number of columns in the key |
| CLUSTERING | CHAR | 1 | 0 | Whether CLUSTER was specified when the index was created |
| CLUSTERED | CHAR | 1 | 0 | Whether the table is actually clustered by the index |
| DBID | SMALLINT | 4 | 0 | Internal identifier of the database |
| OBID | SMALLINT | 4 | 0 | Internal identifier of the index fan set descriptor |
| ISOBID | SMALLINT | 4 | 0 | Internal identifier of the index page set descriptor |
| DBNAME | VARCHAR | 24 | 0 | Name of the database that contains the index |
| INDEXSPACE | VARCHAR | 24 | 0 | Name of the index space |
| FIRSTKEYCARD | INTEGER | 4 | 0 | |
| FULLKEYCARD | INTEGER | 4 | 0 | |
| NLEAF | INTEGER | 4 | 0 | Number of active leaf pages in the index |
| NLEVELS | SMALLINT | 4 | 0 | Number of levels in the index tree |
| BPOOL | CHAR | 8 | 0 | Name of the buffer pool used for the index |
| PGSIZE | SMALLINT | 4 | 0 | Contains the value 4, 8, 16, or 32 which indicates the size, in KB, of the leaf pages in the index |
| ERASERULE | CHAR | 1 | 0 | Whether the data sets are erased when dropped |
| DSETPASS | CHAR | 8 | 0 | |
| CLOSERULE | CHAR | 1 | 0 | Whether the data sets are candidates for closure when the limit on the number of open data sets is reached |
| SPACE | INTEGER | 4 | 0 | Number of kilobytes of DASD storage allocated to the index |
| IBMREQD | CHAR | 1 | 0 | |
| CLUSTERRATIO | SMALLINT | 4 | 0 | Percentage of rows that are in clustering order |
| CREATEDBY | VARCHAR | 128 | 0 | Primary authorization ID of the user who created the index |
| IOFACTOR | SMALLINT | 4 | 0 | |
| PREFETCHFACTOR | SMALLINT | 4 | 0 | |
| STATSTIME | TIMESTAMP | 26 | 0 | RUNSTATS updated the statistics |
| INDEXTYPE | CHAR | 1 | 0 | index type |