SYSCAT.SCPREFTBSPACES catalog view

Each row represents a preferred system temporary table space for the service class.

Table 1. SYSCAT.SCPREFTBSPACES Catalog View
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.
  • A = All types of permanent data; regular table space
  • L = All types of permanent data; large table space
  • T = System temporary tables only
  • U = Created temporary tables or declared temporary tables only