The HSSYSIPA table is used for SYSINDEXPART views. The following table describes the columns in the HSSYSIPA table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| PARTITION | SMALLINT | 4 | 0 | Partition number |
| IXNAME | VARCHAR | 128 | 0 | Name of the index |
| IXCREATOR | VARCHAR | 128 | 0 | The schema of the index |
| PQTY | INTEGER | 4 | 0 | Primary quantity |
| SQTY | SMALLINT | 4 | 0 | Secondary quantity |
| STORTYPE | CHAR | 1 | 0 | Type of storage |
| STORNAME | VARCHAR | 128 | 0 | Name of storage group |
| VCATNAME | VARCHAR | 24 | 0 | Name of integrated catalog |
| CARD | INTEGER | 4 | 0 | |
| FAROFFPOS | INTEGER | 4 | 0 | |
| LEAFDIST | INTEGER | 4 | 0 | 100 times the average number of leaf pages between successive active leaf pages of the index |
| NEAROFFPOS | INTEGER | 4 | 0 | |
| IBMREQD | CHAR | 1 | 0 | |
| LIMITKEY | VARCHAR | 512 | 0 | The high value of the limit key of the partition in an internal format |
| FREEPAGE | SMALLINT | 4 | 0 | Number of pages that are loaded before a page is left as free space |
| PCTFREE | SMALLINT | 4 | 0 | Percentage of each leaf or nonleaf page that is left as free space |
| SPACE | INTEGER | 4 | 0 | Number of kilobytes of DASD storage allocated to the index space partition |
| STATSTIME | TIMESTAMP | 26 | 0 | RUNSTATS updated the statistics |
| INDEXTYPE | CHAR | 1 | 0 | |
| GBPCACHE | CHAR | 1 | 0 | Group buffer pool cache option specified for this index or index partition |