DB2 Version 9.7 for Linux, UNIX, and Windows

HEALTH_TBS_INFO table function

Returns table space information from a health snapshot of a database.

Important: This table function has been deprecated and might be removed in a future release because the health monitor has been deprecated in Version 9.7. For more information, see Health monitor has been deprecated.

Syntax


>>-HEALTH_TBS_INFO--(--dbname--,--dbpartitionnum--)------------><

The schema is SYSPROC.

Table function parameters

dbname: An input argument of type VARCHAR(255) that specifies a valid database name in the same instance as the currently connected database when calling this function. Specify a database name that has a directory entry type of either "Indirect" or "Home", as returned by the LIST DATABASE DIRECTORY command. Specify the null value to take the snapshot from the currently connected database.
dbpartitionnum: An input argument of type INTEGER that specifies a valid database partition number. Specify -1 for the current database partition, or -2 for an aggregate of all active database partitions. An active database partition is a partition where the database is available for connection and use by applications.
If the null value is specified, -1 is set implicitly.

Authorization

EXECUTE privilege on the HEALTH_TBS_INFO table function.

Example

SELECT * FROM TABLE(HEALTH_TBS_INFO('',-1)) AS T

The following example is a sample output from this query.

SNAPSHOT_TIMESTAMP         TABLESPACE_NAME      ...
-------------------------- ----------------...- ...
2006-02-13-12.30.35.027383 SYSCATSPACE          ...
2006-02-13-12.30.35.027383 SYSTOOLSPACE         ...
2006-02-13-12.30.35.027383 SYSTOOLSTMPSPACE     ...
2006-02-13-12.30.35.027383 TEMPSPACE1           ...
2006-02-13-12.30.35.027383 USERSPACE1           ...
                                                   
  5 record(s) selected.

Output from this query (continued).

... ROLLED_UP_ALERT_STATE ROLLED_UP_ALERT_STATE_DETAIL
... --------------------- ----------------------------
...                     4 Alarm                       
...                     1 Normal                      
...                     1 Normal                      
...                     1 Normal                      
...                     4 Alarm

Information returned

Table 1. Information returned by the HEALTH_TBS_INFO table function
Column name	Data type	Description or corresponding monitor element
SNAPSHOT_TIMESTAMP	TIMESTAMP	snapshot_timestamp - Snapshot timestamp
TABLESPACE_NAME	VARCHAR(128)	tablespace_name - Table space name
ROLLED_UP_ALERT_STATE	BIGINT	The most severe alert state captured by this snapshot.
ROLLED_UP_ALERT_ STATE_DETAIL	VARCHAR(20)	The text description of the ROLLED_UP_ALERT_STATE column.