SYSCAT.SCPREFTBSPACES catalog view
Each row represents a preferred system temporary table space for the service class.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
SERVICECLASSNAME | VARCHAR (128) | Name of the service class. | |
PARENTSERVICECLASSNAME | VARCHAR (128) | Service class name of the parent service superclass. | |
TBSPACE | VARCHAR (128) | Name of the table space. | |
SERVICECLASSID | SMALLINT | Identifier for the service class. | |
PARENTSERVICECLASSID | SMALLINT | Identifier for the parent service class for the service class. 0 if the service class is a super service class. | |
TBSPACEID | INTEGER | Identifier for the table space. | |
DATATYPE | CHAR (1) | Type of data that can be stored in this table space.
|