DB2 Version 9.7 for Linux, UNIX, and Windows

tablespace_state_change_object_id - State Change Object Identification monitor element

The object that caused the table space state to be set to "Load pending" or "Delete pending".

Element identifier
tablespace_state_change_object_id
Element type
information
Table 1. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Table Space tablespace_nodeinfo Basic
Usage
This element is meaningful only if the table space state is "Load pending" or "Delete pending". If nonzero, the value of this element matches a value from column TABLEID of view SYSCAT.TABLES.
Note: DB2® LOAD does not set the table space state to Load pending or Delete pending.