The HSSYTAB table is used for SYSTABLES views. The following table describes the columns in the HSSYSTAB table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| NAME | VARCHAR | 128 | 0 | Name of the table, view, or alias |
| CREATOR | VARCHAR | 128 | 0 | The schema of the table, view, or alias |
| TYPE | CHAR | 1 | 0 | Type of object |
| DBNAME | VARCHAR | 24 | 0 | For a table, or a view of tables, the name of the database that contains the table space named in TSNAME |
| TSNAME | VARCHAR | 24 | 0 | For a table, or a view of one table, the name of the table space that contains the table |
| DBID | SMALLINT | 4 | 0 | Internal identifier of the database |
| OBID | SMALLINT | 4 | 0 | Internal identifier of the table |
| COLCOUNT | SMALLINT | 4 | 0 | Number of columns in the table or view |
| EDPROC | VARCHAR | 24 | 0 | Name of the edit procedure |
| VALPROC | VARCHAR | 24 | 0 | Name of the validation procedure |
| CLUSTERTYPE | CHAR | 1 | 0 | Whether RESTRICT ON DROP applies |
| CLUSTERRID | INTEGER | 4 | 0 | |
| CARD | INTEGER | 4 | 0 | |
| NPAGES | INTEGER | 4 | 0 | Total number of pages on which rows of the table appear |
| PCTPAGES | SMALLINT | 4 | 0 | Percentage of active table space pages that contain rows of the table |
| IBMREQD | CHAR | 1 | 0 | |
| REMARKS | VARCHAR | 254 | 0 | A character string provided by the user with the COMMENT statement |
| PARENTS | SMALLINT | 4 | 0 | Number of relationships in which the table is a dependent |
| CHILDREN | SMALLINT | 4 | 0 | Number of relationships in which the table is a parent |
| KEYCOLUMNS | SMALLINT | 4 | 0 | Number of columns in the primary key of the table |
| RECLENGTH | SMALLINT | 4 | 0 | For user tables, the maximum length of any record in the table |
| STATUS | CHAR | 1 | 0 | Indicates the status of the table definition |
| KEYOBID | SMALLINT | 4 | 0 | Internal DB2 identifier of the index that enforces uniqueness of the primary key of the table |
| LABEL | VARCHAR | 30 | 0 | The label as given by a LABEL statement; otherwise, the value is an empty string |
| CHECKFLAG | CHAR | 1 | 0 | The table space that contains the table is in a check pending status |
| CHECKRID | CHAR | 4 | 0 | |
| AUDITING | CHAR | 1 | 0 | Value of the audit option |
| CREATEDBY | VARCHAR | 128 | 0 | Primary authorization ID of the user who created the table, view, or alias |
| LOCATION | VARCHAR | 128 | 0 | Location name of the object of an alias |
| TBCREATOR | VARCHAR | 128 | 0 | name of the creator |
| TBNAME | VARCHAR | 128 | 0 | the name of the base table |
| CREATEDTS | TIMESTAMP | 26 | 0 | Time when the CREATE statement was executed for the table, view, or alias |
| ALTEREDTS | TIMESTAMP | 26 | 0 | Time when the CREATE statement was executed for the table, view, or alias |
| DATACAPTURE | CHAR | 1 | 0 | Records the value of the DATA CAPTURE option for a table |
| RBA1 | CHAR | 6 | 0 | The log RBA when the table was created |
| RBA2 | CHAR | 6 | 0 | The log RBA when the table was created |
| PCTROWCOMP | SMALLINT | 4 | 0 | Percentage of rows compressed within the total number of active rows in the table |
| STATSTIME | TIMESTAMP | 26 | 0 | RUNSTATS updated the statistics |
| CHECKS | SMALLINT | 4 | 0 | Number of check constraints defined on the table |
| CARDF | FLOAT | 2 | 0 | Total number of rows in the table or total number of LOBs in an auxiliary table |
| CHECKRID5B | CHAR | 5 | 0 | Blank if the table or partition is not in a check pending status |
| ENCODING_SCHEME | CHAR | 1 | 0 | Encoding scheme for tables |
| TABLESTATUS | VARCHAR | 30 | 0 | Indicates the reason for an incomplete table definition |