HEALTH_DBM_INFO table function

The HEALTH_DBM_INFO function returns information from a health snapshot of the database manager.

Important: This table function has been deprecated and might be removed in a future release because the health monitor has been deprecated. It is not supported in Db2® pureScale® environments. For more information, see Health monitor has been deprecated..

Syntax

The schema is SYSPROC.

Table function parameter

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.

If the null value is specified, -1 is set implicitly.

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_DBM_INFO(-1)) AS T

The following is an example of output from this query.

SNAPSHOT_TIMESTAMP         SERVER_INSTANCE_NAME       ROLLED_UP_ALERT_STATE  ...
-------------------------- --------------------...--- ---------------------  ...
2006-02-13-12.30.19.663924 DB2                                            4  ...
                                                                                
  1 record(s) selected.

Output from this query (continued).

... ROLLED_UP_ALERT_STATE_DETAIL DB2START_TIME              ...
... ---------------------------- -------------------------- ...
... Alarm                        2006-02-09-10.56.18.126182 ...

Output from this query (continued).

... LAST_RESET        NUM_NODES_IN_DB2_INSTANCE
... -----------...--- -------------------------
... -                                         1

Information returned

Table 1. Information returned by the HEALTH_DBM_INFO table function
Column name	Data type	Description or corresponding monitor element
SNAPSHOT_TIMESTAMP	TIMESTAMP	snapshot_timestamp - Snapshot timestamp
SERVER_INSTANCE_NAME	VARCHAR(128)	server_instance_name - Server instance 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.
DB2START_TIME	TIMESTAMP	db2start_time - Start database manager timestamp
LAST_RESET	TIMESTAMP	last_reset - Last reset timestamp
NUM_NODES_IN_DB2_INSTANCE	INTEGER	num_nodes_in_db2_instance - Number of nodes in database partition