DB2 Version 9.7 for Linux, UNIX, and Windows

tablespace_name - Table space name monitor element

The name of a table space.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_CONTAINER table function - Get table space container metrics	Always collected
MON_GET_TABLESPACE table function - Get table space metrics	Always collected
MON_GET_EXTENT_MOVEMENT_STATUS - Get extent movement progress status metrics	Always collected

Table 2. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Table Space	tablespace	Basic
Lock	appl_lock_list	Basic
Lock	lock	Lock
Lock	lock_wait	Lock

Table 3. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Locking	-	-
Deadlocks¹	lock	-
Deadlocks¹	event_dlconn	-
Deadlocks with Details¹	event_detailed_dlconn	-
Table Space	tablespace_list	-

1: This option has been deprecated. Its use is no longer recommended and might be removed in a future release. Use the CREATE EVENT MONITOR FOR LOCKING statement to monitor lock-related events, such as lock timeouts, lock waits, and deadlocks.

Usage

This element can help you determine the source of contention for resources.

It is equivalent to the TBSPACE column in the database catalog table SYSCAT.TABLESPACES. At the application level, application-lock level, and deadlock monitoring level, this is the name of the table space that the application is waiting to lock. Another application currently holds a lock on this table space.

At the lock level, this is the name of the table space against which the application currently holds a lock.

At the table space level (when the buffer pool monitor group is ON), this is the name of the table space for which information is returned.

This element will not be returned for a table lock held on a partitioned table.