Health monitor SQL table functions

You can use SQL table functions to capture snapshots of your database. The snapshots that you create are used by the heath monitor to assess the current state of your database.The health monitor SQL table functions have been deprecated.

Important: The health monitor, health indicators, and related components have been deprecated and might be removed in a future release. Health monitor is not supported in Db2® pureScale® environments. For more information, see Health monitor has been deprecated.
The following table lists all of the snapshot table functions. Each table function corresponds to a health snapshot request type.
Table 1. Snapshot monitor SQL table functions
Monitor level SQL table function Information returned
Database manager HEALTH_DBM_INFO Basic information about the health snapshot from the database manager level
Database manager HEALTH_DBM_HI Health indicator information from the database manager level
Database manager HEALTH_DBM_HI_HIS Health indicator history information from the database manager level
Database HEALTH_DB_INFO Basic information about the health snapshot from a database
Database HEALTH_DB_HI Health indicator information from a database
Database HEALTH_DB_HI_HIS Health indicator history information from a database
Database HEALTH_DB_HIC Collection information for collection health indicators for a database
Database HEALTH_DB_HIC_HIS Collection history information for collection health indicators for a database
Table space HEALTH_TBS_INFO Basic information about the health snapshot for the table spaces for a database
Table space HEALTH_TBS_HI Health indicator information about the table spaces for a database
Table space HEALTH_TBS_HI_HIS Health indicator history information about the table spaces for a database
Table space HEALTH_CONT_INFO Basic information about the health snapshot for the containers for a database
Table space HEALTH_CONT_HI Health indicator information about the containers for a database
Table space HEALTH_CONT_HI_HIS Health indicator history information about the containers for a database