HEALTH_DBM_HI_HIS table function
The HEALTH_DBM_HI_HIS table function returns health indicator history 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_HI_HIS(-1)) AS TThe following is an example of output from this query.
SNAPSHOT_TIMESTAMP HI_ID SERVER_INSTANCE_NAME HI_VALUE ...
-------------------------- -----...- --------------------...- -------- ...
2006-02-13-12.30.20.460905 1 DB2 0 ...
2006-02-13-12.30.20.460905 1 DB2 0 ...
2006-02-13-12.30.20.460905 1 DB2 0 ...
2006-02-13-12.30.20.460905 1 DB2 0 ...
2006-02-13-12.30.20.460905 1 DB2 0 ...
2006-02-13-12.30.20.460905 1 DB2 0 ...
2006-02-13-12.30.20.460905 1 DB2 0 ...
2006-02-13-12.30.20.460905 1 DB2 0 ...
2006-02-13-12.30.20.460905 1 DB2 0 ...
2006-02-13-12.30.20.460905 4 DB2 100 ...
2006-02-13-12.30.20.460905 4 DB2 100 ...
2006-02-13-12.30.20.460905 4 DB2 100 ...
2006-02-13-12.30.20.460905 4 DB2 100 ...
2006-02-13-12.30.20.460905 4 DB2 60 ...
2006-02-13-12.30.20.460905 4 DB2 60 ...
2006-02-13-12.30.20.460905 4 DB2 60 ...
2006-02-13-12.30.20.460905 4 DB2 60 ...
2006-02-13-12.30.20.460905 4 DB2 60 ...
18 record(s) selected. Output for this query
(continued).
... HI_TIMESTAMP HI_ALERT_STATE HI_ALERT_STATE_DETAIL ...
... -------------------------- -------------- --------------------- ...
... 2006-02-13-12.21.25.649000 1 Normal ...
... 2006-02-13-12.16.25.911000 1 Normal ...
... 2006-02-13-12.11.25.377000 1 Normal ...
... 2006-02-13-12.06.26.168000 1 Normal ...
... 2006-02-13-12.01.25.165000 1 Normal ...
... 2006-02-13-11.56.25.927000 1 Normal ...
... 2006-02-13-11.51.25.452000 1 Normal ...
... 2006-02-13-11.46.25.211000 1 Normal ...
... 2006-02-13-11.41.25.972000 1 Normal ...
... 2006-02-13-12.21.25.649000 4 Alarm ...
... 2006-02-13-12.16.25.911000 4 Alarm ...
... 2006-02-13-12.11.25.377000 4 Alarm ...
... 2006-02-13-12.06.26.168000 4 Alarm ...
... 2006-02-13-12.01.25.165000 1 Normal ...
... 2006-02-13-11.56.25.927000 1 Normal ...
... 2006-02-13-11.51.25.452000 1 Normal ...
... 2006-02-13-11.46.25.211000 1 Normal ...
... 2006-02-13-11.41.25.972000 1 Normal ...
Output for this query (continued).
... HI_FORMULA HI_ADDITIONAL_INFO
... -------------------------...- ------------------
... 0 -
... 0 -
... 0 -
... 0 -
... 0 -
... 0 -
... 0 -
... 0 -
... 0 -
... ((327680 / 327680) * 100) -
... ((327680 / 327680) * 100) -
... ((327680 / 327680) * 100) -
... ((327680 / 327680) * 100) -
... ((196608 / 327680) * 100) -
... ((196608 / 327680) * 100) -
... ((196608 / 327680) * 100) -
... ((196608 / 327680) * 100) -
... ((196608 / 327680) * 100) -Information returned
| Column name | Data type | Description or corresponding monitor element |
|---|---|---|
| SNAPSHOT_TIMESTAMP | TIMESTAMP | snapshot_timestamp - Snapshot timestamp |
| HI_ID | BIGINT | A number that uniquely identifies the health indicator in the snapshot data stream. |
| SERVER_INSTANCE_NAME | VARCHAR(128) | server_instance_name - Server instance name |
| HI_VALUE | SMALLINT | The value of the health indicator. |
| HI_TIMESTAMP | TIMESTAMP | The date and time that the alert was generated. |
| HI_ALERT_STATE | BIGINT | The severity of the alert. |
| HI_ALERT_STATE_DETAIL | VARCHAR(20) | The text description of the HI_ALERT_STATE column. |
| HI_FORMULA | VARCHAR(2048) | The formula used to calculate the health indicator. |
| HI_ADDITIONAL_INFO | VARCHAR(4096) | Additional information about the health indicator. |