The HSSYSDBA table is used for SYSDATABASE views. The following table describes the columns in the HSSYSDBA table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| NAME | VARCHAR | 24 | 0 | Database name |
| CREATOR | VARCHAR | 128 | 0 | Authorization ID of the owner of the database |
| STGROUP | VARCHAR | 128 | 0 | Name of the default storage group of the database |
| BPOOL | CHAR | 8 | 0 | Name of the default buffer pool of the table space |
| DBID | SAMLLINT | 4 | 0 | Internal identifier of the database |
| IBMREQD | CHAR | 1 | 0 | |
| CREATEDBY | VARCHAR | 128 | 0 | Primary authorization ID of the user who created the database |
| ROSHARE | CHAR | 1 | 0 | |
| TIMESTAMP | TIMESTAMP | 26 | 0 | |
| TYPE | CHAR | 1 | 0 | Type of database |
| GROUP_MEMBER | VARCHAR | 24 | 0 | The DB2 data sharing member name of the DB2 subsystem that uses this work file database |