The HSSYTPA table is used for SYSTABLEPART views. The following table describes the columns in the HSSYSTPA table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| PARTITION | SMALLINT | 4 | 0 | Partition number; 0 if table space is not partitioned |
| TSNAME | VARCHAR | 24 | 0 | Name of the table space |
| DBNAME | VARCHAR | 24 | 0 | Name of the database that contains the table space |
| IXNAME | VARCHAR | 128 | 0 | Name of the partitioning index |
| IXCREATOR | VARCHAR | 128 | 0 | The schema of the partitioning index |
| PQTY | INTEGER | 4 | 0 | Primary quantity |
| SQTY | SMALLINT | 4 | 0 | Secondary quantity |
| STORTYPE | CHAR | 1 | 0 | Type of storage allocation |
| STORNAME | VARCHAR | 128 | 0 | Name of storage group used for space allocation |
| VCATNAME | VARCHAR | 24 | 0 | Name of integrated catalog facility catalog used for space allocation |
| CARD | INTEGER | 4 | 0 | Number of rows in the table space or partition |
| FARINDREF | INTEGER | 4 | 0 | Number of rows that have been relocated far from their original page |
| NEARINDREF | INTEGER | 4 | 0 | Number of rows that have been relocated near their original page |
| PERCACTIVE | SMALLINT | 4 | 0 | Percentage of space occupied by rows of data from active tables |
| PERCDROP | SMALLINT | 4 | 0 | Percentage of space occupied by rows of dropped tables |
| IBMREQD | CHAR | 1 | 0 | |
| LIMITKEY | VARCHAR | 512 | 0 | The high value of the partition in external format |
| FREEPAGE | SMALLINT | 4 | 0 | Number of pages loaded before a page is left as free space |
| PCTFREE | SMALLINT | 4 | 0 | Percentage of each page left as free space |
| CHECKFLAG | CHAR | 1 | 0 | |
| CHECKRID | CHAR | 4 | 0 | |
| SPACE | INTEGER | 4 | 0 | |
| COMPRESS | CHAR | 1 | 0 | |
| PAGESAVE | SMALLINT | 4 | 0 | |
| STATSTIME | TIMESTAMP | 26 | 0 | RUNSTATS updated the statistics |
| GBPCACHE | CHAR | 1 | 0 | Group buffer pool cache option specified for this table space or table space partition |