The HSSYTSP table is used for SYSTABLESPACE views. The following table describes the columns in the HSSYSTSP table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| NAME | VARCHAR | 24 | 0 | Name of the table space |
| CREATOR | VARCHAR | 128 | 0 | Authorization ID of the owner of the table space |
| DBNAME | VARCHAR | 24 | 0 | Name of the database that contains the table space |
| DBID | SMALLINT | 4 | 0 | Internal identifier of the database which contains the table Space |
| OBID | SMALLINT | 4 | 0 | Internal identifier of the table space file descriptor |
| PSID | SMALLINT | 4 | 0 | Internal identifier of the table space page set descriptor |
| BPOOL | CHAR | 8 | 0 | Name of the buffer pool used for the table space |
| PARTITIONS | SMALLINT | 4 | 0 | Number of partitions of the table space; 0 if the table space is not partitioned |
| LOCKRULE | CHAR | 1 | 0 | Lock size of the table space |
| PGSIZE | SMALLINT | 4 | 0 | Size of pages in the table space in kilobytes |
| ERASERULE | CHAR | 1 | 0 | Whether the data sets are to be erased when dropped |
| STATUS | CHAR | 1 | 0 | Availability status of the table space |
| IMPLICIT | CHAR | 1 | 0 | Whether the table space was created implicitly |
| NTABLES | SMALLINT | 4 | 0 | Number of tables defined in the table space |
| NACTIVE | INTEGER | 4 | 0 | Number of active pages in the table space |
| DSETPASS | VARCHAR | 24 | 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 | |
| IBMREQD | CHAR | 1 | 0 | |
| ROOTNAME | VARCHAR | 54 | 0 | |
| ROOTCREATOR | VARCHAR | 24 | 0 | |
| SEGSIZE | SMALLINT | 4 | 0 | Number of pages in each segment of a segmented table space |
| CREATEDBY | VARCHAR | 128 | 0 | Primary authorization ID of the user who created the table space |
| STATSTIME | TIMESTAMP | 26 | 0 | RUNSTATS updated the statistics |
| LOCKMAX | INTEGER | 4 | 0 | The maximum number of locks per user to acquire for the table or table space before escalating to the next locking level |
| TYPE | CHAR | 1 | 0 | The type of table space |