A tabela SYSPENDINGOBJECTS contém o nome e as informações do OBID sobre os objetos que estão com criação pendente.
Os conjuntos de dados para esses objetos são criados, mas a definição do objeto não foi materializada no catálogo.
As entradas nesta tabela existem apenas durante o tempo entre a geração dos nomes dos novos objetos e a materialização da definição do catálogo dos novos objetos.
O esquema é SYSIBM.
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.
| 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 |
