DB2 Version 9.7 for Linux, UNIX, and Windows

tablespace_state - Table space state monitor element

This element describes the current state of a table space.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_TABLESPACE table function - Get table space metrics	DATA OBJECT METRICS BASE

Table 2. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Table Space	tablespace_nodeinfo	Basic

Usage

In administrative views and table functions, this monitor element returns a text identifier based on defines in sqlutil.h, and is combination of the following separated by a '+' sign:

BACKUP_IN_PROGRESS
BACKUP_PENDING
DELETE_PENDING
DISABLE_PENDING
DROP_PENDING
LOAD_IN_PROGRESS
LOAD_PENDING
MOVE_IN_PROGRESS
NORMAL
OFFLINE
PSTAT_CREATION
PSTAT_DELETION
QUIESCED_EXCLUSIVE
QUIESCED_SHARE
QUIESCED_UPDATE
REBAL_IN_PROGRESS
REDIST_IN_PROGRESS
REORG_IN_PROGRESS
RESTORE_IN_PROGRESS
RESTORE_PENDING
ROLLFORWARD_IN_PROGRESS
ROLLFORWARD_PENDING
STORDEF_ALLOWED
STORDEF_CHANGED
STORDEF_FINAL_VERSION
STORDEF_PENDING
SUSPEND_WRITE

This element contains a hexadecimal value indicating the current table space state. The externally visible state of a table space is composed of the hexadecimal sum of certain state values. For example, if the state is "quiesced: EXCLUSIVE" and "Load pending", the value is 0x0004 + 0x0008, which is 0x000c. Use the db2tbst command to obtain the table space state associated with a given hexadecimal value.

Table 3. Bit definitions listed in sqlutil.h
Hexadecimal Value	Decimal Value	State
0x0	0	Normal (see the definition SQLB_NORMAL in sqlutil.h)
0x1	1	Quiesced: SHARE
0x2	2	Quiesced: UPDATE
0x4	4	Quiesced: EXCLUSIVE
0x8	8	Load pending
0x10	16	Delete pending
0x20	32	Backup pending
0x40	64	Roll forward in progress
0x80	128	Roll forward pending
0x100	256	Restore pending
0x100	256	Recovery pending (not used)
0x200	512	Disable pending
0x400	1024	Reorg in progress
0x800	2048	Backup in progress
0x1000	4096	Storage must be defined
0x2000	8192	Restore in progress
0x4000	16384	Offline and not accessible
0x8000	32768	Drop pending
0x10000	65536	No write is allowed
0x20000	131072	Load in progress
0x40000	262144	Redistribute in progress
0x80000	524288	Move in progress
0x2000000	33554432	Storage may be defined
0x4000000	67108864	Storage Definition is in 'final' state
0x8000000	134217728	Storage Definition was changed prior to rollforward
0x10000000	268435456	DMS rebalancer is active
0x20000000	536870912	TBS deletion in progress
0x40000000	1073741824	TBS creation in progress

Note: DB2® LOAD does not set the table space state to Load pending or Delete pending.