HEALTH_CONT_INFO table function
The HEALTH_CONT_INFO table function returns container 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. It is not
supported in Db2®
pureScale® environments. For more information, see Health monitor has been deprecated..
Syntax
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.
- member
- An input argument of type INTEGER that specifies a valid database member number. Specify -1 for the current database member, or -2 for an aggregate of all active database members. An active database member is a member where the database is available for connection and use by applications.
Authorization
One of the following authorities is required to execute the routine:
- EXECUTE privilege on the routine
- DATAACCESS authority
- DBADM authority
- SQLADM authority
Default PUBLIC privilege
In a non-restrictive database, EXECUTE privilege is granted to PUBLIC when the function is automatically created.
Example
SELECT * FROM TABLE(HEALTH_CONT_INFO('',-1)) AS T
The following is an example of output from this query.
SNAPSHOT_TIMESTAMP CONTAINER_NAME ...
-------------------------- -----------------------------------------...- ...
2006-02-13-12.30.40.541209 D:\DB2\NODE0000\SAMPLE\T0000000\C0000000.CAT ...
2006-02-13-12.30.40.541209 D:\DB2\NODE0000\SAMPLE\T0000003\C0000000.LRG ...
2006-02-13-12.30.40.541209 D:\DB2\NODE0000\SAMPLE\T0000004\C0000000.UTM ...
2006-02-13-12.30.40.541209 D:\DB2\NODE0000\SAMPLE\T0000001\C0000000.TMP ...
2006-02-13-12.30.40.541209 D:\DB2\NODE0000\SAMPLE\T0000002\C0000000.LRG ...
5 record(s) selected.
Output from this query (continued).
... TABLESPACE_NAME NODE_NUMBER ...
... ---------------...- ----------- ...
... SYSCATSPACE - ...
... SYSTOOLSPACE - ...
... SYSTOOLSTMPSPACE - ...
... TEMPSPACE1 - ...
... USERSPACE1 - ...
Output from this query (continued).
... ROLLED_UP_ALERT_STATE ROLLED_UP_ALERT_STATE_DETAIL
... --------------------- ----------------------------
... 1 Normal
... 1 Normal
... 1 Normal
... 1 Normal
... 1 Normal
Information returned
Column name | Data type | Description or corresponding monitor element |
---|---|---|
SNAPSHOT_TIMESTAMP | TIMESTAMP | snapshot_timestamp - Snapshot timestamp |
CONTAINER_NAME | VARCHAR(256) | container_name - Container name |
TABLESPACE_NAME | VARCHAR(128) | tablespace_name - Table space name |
NODE_NUMBER | INTEGER | node_number - Node number |
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. |