DB2 Version 9.7 for Linux, UNIX, and Windows

Health monitor interface mappings to logical data groups

The following table lists all the supported health snapshot request types.

Table 1. Health monitor interface mappings to logical data groups
API request type	CLP command	SQL table function	Logical data groups
`SQLMA_DB2`	`get health snapshot for dbm`	`HEALTH_DBM_INFO`	db2
	`get health snapshot for dbm`	`HEALTH_DBM_HI`	health_indicator
	`get health snapshot for dbm show detail`	`HEALTH_DBM_HI_HIS`	health_indicator_history
`SQLMA_DBASE`	`get health snapshot for database on dbname`	`HEALTH_DB_INFO`	dbase
	`get health snapshot for database on dbname`	`HEALTH_DB_HI`	health_indicator
	`get health snapshot for database on dbname show detail`	`HEALTH_DB_HI_HIS`	health_indicator_history
`SQLMA_DBASE with SQLM_HMON_OPT_COLL_FULL in the agent_id`	`get health snapshot for database on dbname with full collection`	`HEALTH_DB_HIC`	health_indicator, hi_obj_list
`SQLMA_DBASE with SQLM_HMON_OPT_COLL_FULL in the agent_id`	`get health snapshot for database on dbname show detail with full collection`	`HEALTH_DB_HIC_HIST`	health_indicator_history, hi_obj_list
`SQLMA_DBASE_ALL`	`get health snapshot for all databases`	`HEALTH_DB_INFO`	dbase
	`get health snapshot for all databases`	`HEALTH_DB_HI`	health_indicator
	`get health snapshot for all databases show detail`	`HEALTH_DB_HI_HIS`	health_indicator_history
`SQLMA_DBASE_TABLESPACES`	`get health snapshot for tablespaces on dbname`	`HEALTH_TS_INFO`	tablespace
		`HEALTH_TS_HI`	health_indicator
		`HEALTH_CONT_INFO`	tablespace_container
		`HEALTH_CONT_HI`	health_indicator
	`get health snapshot for tablespaces on dbname show detail`	`HEALTH_TS_HI_HIS`	health_indicator_history
	`get health snapshot for tablespaces on dbname show detail`	`HEALTH_CONT_HI_HIS`	health_indicator_history

The following figure shows the order that logical data groupings can appear in a health snapshot data stream.

Figure 1. Health snapshot logical data groupings