HSSYSIPA

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