SYSPENDINGDDL catalog table

The 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. The schema is SYSIBM.

Table 1. SYSIBM.SYSPENDINGDDL table column descriptions
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. I The object is an index S The object is a table space T The object is a table	G
STATEMENT_TYPE	CHAR(1) NOT NULL	The type of the statement for the pending option. A An ALTER statement R A RECOVER statement	G
OPTION_ENVID	INTEGER NOT NULL	Internal identifier of the environment for the pending option.	G
OPTION_KEYWORD	VARCHAR(128) NOT NULL	If the row is inserted into this table during execution of a data definition statement, this value is the name of the pending option. If the row is inserted into this table during recovery to a prior point in time, this value is the name of the RECOVER option.	G
OPTION_VALUE	VARCHAR(4000) NOT NULL	If the row is inserted into this table during execution of a data definition statement, this value is the value of the pending option. If the row is inserted into this table during recovery to a prior point in time, this value is the value of the RECOVER option.	G
OPTION_SEQNO	SMALLINT NOT NULL	The sequence of the pending option within the statement.	G
CREATEDTS	TIMESTAMP(12) 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 was provided with the Db2 product code. 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
COLNAME	VARCHAR(128) NOT NULL WITH DEFAULT	The name of the column with a pending definition change.	G
PARTITION	SMALLINT NOT NULL	The physical partition number that was specified in the alter statement. The value is 0 if no physical partition number was specified.	G
PARTITION_ KEYWORD	VARCHAR(18) NOT NULL WITH DEFAULT	This column is populated if the PARTITION column has a non-zero value. The keyword that is associated with the PARTITION clause of the ALTER TABLE statement. For example, suppose that you issued the following statement: `ALTER TABLE ALTER PARTITION` In that case, this column contains ALTER.	G
COLUMN_ KEYWORD	VARCHAR(18) NOT NULL WITH DEFAULT	This column contains the keyword that corresponds to the column that is listed in COLNAME.	G
REORG_SCOPE_ LOWPART	SMALLINT	Logical partition number of the lowest partition in the range for REORG to materialize pending definition changes. Adjacent logical partitions must be reorganized together to materialize pending definition changes. The value is 0 if the range is the entire partitioned table space or index space, or if the record is generated by the RECOVER utility. This column contains the null value when the value is unknown for pending definition changes executed prior to Db2 12.
REORG_SCOPE_ HIGHPART	SMALLINT	Logical partition number of the highest partition in the range for REORG to materialize pending definition changes. Adjacent logical partitions must be reorganized together to materialize pending definition changes. The value is 0 if the range is the entire partitioned table space or index space, or if the record is generated by the RECOVER utility. This column contains the null value when the value is unknown for pending definition changes executed prior to Db2 12.