DB2 Version 9.7 for Linux, UNIX, and Windows

tablespace_state_change_ts_id - State Change Table Space Identification monitor element

If the table space state is "Load pending" or "Delete pending", this shows the table space ID of the object that caused the table space state to be set.

Element identifier: tablespace_state_change_ts_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 TABLESPACEID of view SYSCAT.TABLES.
Note: DB2® LOAD does not set the table space state to Load pending or Delete pending.