HSSYSTSP

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