HSSYSTPA

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 765 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