HEALTH_DB_HIC_HIS table function

Returns collection health indicator history 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. 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 all databases under the database instance.

member

An input argument of type INTEGER that specifies a valid database member number. Specify -1 for the current database member, or -2 for all active database partitions. 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_DB_HIC_HIS('',-1)) AS T

The following is an example of output from this query.

HI_HIS_ENTRY_NUM SNAPSHOT_TIMESTAMP         HI_ID                ...
---------------- -------------------------- -------------------- ...
               1 2006-02-13-12.30.34.496720                 1015 ...
               2 2006-02-13-12.30.34.496720                 1022 ...
               3 2006-02-13-12.30.34.496720                 1022 ...
               4 2006-02-13-12.30.34.496720                 1022 ...
               5 2006-02-13-12.30.34.496720                 1022 ...
               6 2006-02-13-12.30.34.496720                 1022 ...
               7 2006-02-13-12.30.34.496720                 1022 ...
               8 2006-02-13-12.30.34.496720                 1022 ...
               9 2006-02-13-12.30.34.496720                 1022 ...
              10 2006-02-13-12.30.34.496720                 1022 ...
                                                                    
  10 record(s) selected.

Output from this query (continued).

... DB_NAME     HI_OBJ_NAME                            HI_OBJ_STATE ...
... -------...- ----------------------------------...- ------------ ...
... SAMPLE      "JESSICAE"."EMPLOYEE"                             2 ...
... SAMPLE      "SYSIBM"."SYSDATAPARTITIONEXPRESSION"             2 ...
... SAMPLE      "SYSIBM"."SYSDATAPARTITIONEXPRESSION"             2 ...
... SAMPLE      "SYSIBM"."SYSDATAPARTITIONEXPRESSION"             2 ...
... SAMPLE      "SYSIBM"."SYSDATAPARTITIONEXPRESSION"             1 ...
... SAMPLE      "SYSIBM"."SYSDATAPARTITIONEXPRESSION"             1 ...
... SAMPLE      "SYSIBM"."SYSDATAPARTITIONEXPRESSION"             1 ...
... SAMPLE      "SYSIBM"."SYSDATAPARTITIONEXPRESSION"             1 ...
... SAMPLE      "SYSIBM"."SYSDATAPARTITIONEXPRESSION"             1 ...
... SAMPLE      "SYSIBM"."SYSDATAPARTITIONEXPRESSION"             1 ...

Output from this query (continued).

... HI_OBJ_STATE_DETAIL  HI_TIMESTAMP              
... -------------------- --------------------------
... Attention            2006-02-10-09.04.57.000000
... Attention            2006-02-13-12.27.56.000000
... Attention            2006-02-13-12.26.27.000000
... Attention            2006-02-13-12.24.56.000000
... Normal               2006-02-13-12.23.28.000000
... Normal               2006-02-13-12.21.56.000000
... Normal               2006-02-13-12.20.26.000000
... Normal               2006-02-13-12.18.57.000000
... Normal               2006-02-13-12.17.27.000000
... Normal               2006-02-13-12.15.56.000000

Information returned

Table 1. Information returned by the HEALTH_DB_HIC_HIS table function
Column name	Data type	Description or corresponding monitor element
HI_HIS_ENTRY_NUM	SMALLINT	A number that uniquely identifies the history entry.
SNAPSHOT_TIMESTAMP	TIMESTAMP	snapshot_timestamp - Snapshot timestamp
HI_ID	BIGINT	A number that uniquely identifies the health indicator in the snapshot data stream.
DB_NAME	VARCHAR(128)	db_name - Database name
HI_OBJ_NAME	VARCHAR(512)	A name that uniquely identifies an object in the collection.
HI_OBJ_STATE	SMALLINT	The state of the object. Valid states (defined in sqlmon.h) include: NORMAL (1). Action is not required on this object. ATTENTION (2). Automation is not enabled for this health indicator; action must be taken manually. AUTOMATED (5). Automation is enabled for this health indicator; action will be started automatically. AUTOMATE_FAILED (6). Automation is enabled for this health indicator; action was started, but could not complete successfully. Manual intervention is now required.
HI_OBJ_STATE_DETAIL	VARCHAR(20)	A translated string version of the value in the HI_OBJ_STATE column.
HI_TIMESTAMP	TIMESTAMP	The date and time that the alert was generated.