SYSPENDINGOBJECTS catalog table

The SYSPENDINGOBJECTS table contains the name of and OBID information about objects that are the pending creation. The data sets for these objects are created but the object definition have not been materialized to the catalog. The entries in this table only exist during the time between when the names of the new objects are generated and when the catalog definition of the new objects are materialized. The schema is SYSIBM.

Table 1. SYSIBM.SYSPENDINGOBJECTS table column descriptions
Column name Data type Description Use
DBNAME
VARCHAR(24)
NOT NULL
 Name of the database. G
TSNAME
VARCHAR(24)
NOT NULL
 Name of the base table space. G
DBID
SMALLINT
NOT NULL
 Internal identifier of the database. S
PSID
SMALLINT
NOT NULL
 Internal identifier of the base table space page set descriptor. S
PARTITION
SMALLINT
NOT NULL
 Partition number with which the object is associated. G
COLNAME
VARCHAR(128)
NOT NULL
 Name of the column contained in the base table space with which the object is associated. G
OBJSCHEMA
VARCHAR(128)
NOT NULL
 The qualifier of the object. G
OBJNAME
VARCHAR(128)
NOT NULL
 Name of the object. G
OBJTYPE
CHAR(1)
NOT NULL
 Type of object identified by OBJSCHEMA and OBJNAME.
I
The object is an index
S
The object is a table space
T
The object is a table
 G
INDEXSPACE
VARCHAR(24)
NOT NULL
 Name of the index space. An empty string if the object is not an index. G
OBJOBID
SMALLINT
NOT NULL
 Internal identifier of the object. S
OBJPSID
SMALLINT
NOT NULL
 Internal identifier of the object page set descriptor, or 0 if the object does not have a page set descriptor. S