SYSIBM.SYSPENDINGDDL table
The SYSIBM.SYSPENDINGDDL table contains information about which objects have pending definition changes. The entries only exist during the window between when the pending option is executed and when the utility applies these pending changes to the object.
| Column name | Data type | Description | Use |
|---|---|---|---|
| DBNAME | VARCHAR(24)
NOT NULL |
Name of the database for the pending option. | G |
| TSNAME | VARCHAR(24)
NOT NULL |
Name of the table space for the pending option. | G |
| DBID | SMALLINT
NOT NULL |
Internal identifier of the database. | S |
| PSID | SMALLINT
NOT NULL |
Internal identifier of the table space page set descriptor. | S |
| OBJSCHEMA | VARCHAR(128)
NOT NULL |
The qualifier of the object that contains the pending option. | G |
| OBJNAME | VARCHAR(128)
NOT NULL |
Name of the object that contains the pending option. | G |
| OBJOBID | SMALLINT
NOT NULL |
Internal identifier of the object. | S |
| OBJTYPE | CHAR(1)
NOT NULL |
Type of object that is identified by OBJSCHEMA
and OBJNAME.
|
G |
| STATEMENT_TYPE | CHAR(1)
NOT NULL |
The type of the statement for the pending option.
|
G |
| OPTION_ENVID | INTEGER
NOT NULL |
Internal identifier of the environment for the pending option. | G |
| OPTION_KEYWORD | VARCHAR(128)
NOT NULL |
The keyword of the pending option. | G |
| OPTION_VALUE | VARCHAR(4000)
NOT NULL |
The value of the pending option as a string. | G |
| OPTION_SEQNO | SMALLINT
NOT NULL |
The sequence of the pending option within the statement. | G |
| CREATEDTS | TIMESTAMP
NOT NULL |
Timestamp when the pending option was created. | G |
| RELCREATED | CHAR(1)
NOT NULL |
The release of DB2® that is used to create the object. See Release dependency indicators for the values. | G |
| IBMREQD | CHAR(1)
NOT NULL |
A value of Y indicates that the row came from the
basic machine- readable material (MRM) tape. For all other values,
see Release
dependency indicators. The value in this field is not a reliable indicator of release dependencies. RELCREATED should be used instead. |
G |
| ROWID | ROWID
|
ID to support LOB columns for source text | G |
| STATEMENT_TEXT | CLOB(2M)
NOT NULL |
The source text of the original statement for the pending option. | G |
