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.
| 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 |