DB2 Version 9.7 for Linux, UNIX, and Windows

HEALTH_DBM_HI_HIS table function

The HEALTH_DBM_HI_HIS table function returns health indicator history information from a health snapshot of the DB2® database manager.

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_DBM_HI_HIS--(--dbpartitionnum--)---------------------><

The schema is SYSPROC.

Table function parameter

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_DBM_HI_HIS table function.

Example

SELECT * FROM TABLE(HEALTH_DBM_HI_HIS(-1)) AS T

The following example is a sample 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

Table 1. Information returned by the HEALTH_DBM_HI_HIS table function
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.