Snapshot monitor interface mappings to logical data groups

Each individual API request type, CLP command, and SQL administrative view only captures monitor data from a subset of all the logical data groups.

The following table lists several ways of accessing snapshot monitor data. All snapshot monitor data is stored in monitor elements, which are categorized by logical data groups.

Each individual API request type, CLP command, and SQL administrative view listed in this table returns monitor elements from the logical data groups listed in the right-most column.

Note:

There are a number of API request types and CLP commands for which there are no corresponding SQL administrative view. For other API request types and CLP commands, individual SQL administrative views capture subsets of the associated logical data groups.
Some monitor elements are returned only if the associated monitor switch is set ON. See the individual monitor elements to determine if a required element is under switch control.

Table 1. Snapshot Monitor Interface Mappings to Logical Data Groups
db2GetSnapshot API request type	CLP command	SQL administrative view	Logical data groups
`SQLMA_APPLINFO_ALL`	`list applications [show detail]`	`APPLICATIONS`	appl_info
`SQLMA_DBASE_APPLINFO`	`list applications for database dbname [show detail]`	`APPLICATIONS`	appl_info
`SQLMA_DCS_APPLINFO_ALL`	`list dcs applications [show detail]`		dcs_appl_info
`SQLMA_DB2`	`get snapshot for dbm`	`SNAPDBM`	db2
		`SNAPFCM`	fcm
		`SNAPFCMPART`	fcm_node
		`SNAPUTIL`	utility_info
		`SNAPUTIL_PROGRESS`	progress, progress_info
		`SNAPDBM_MEMORY_POOL`	memory_pool
	`get dbm monitor switches`	`SNAPSWITCHES`	switch_list
`SQLMA_DBASE`	`get snapshot for database on dbname`	`SNAPDB`	dbase
		`SNAPDETAILLOG`	detail_log
		`ADMIN_GET_STORAGE_PATHS`	db_storage_group
			rollforward
			db_sto_path_info
		`SNAPTBSP`	tablespace
		`SNAPDB_MEMORY_POOL`	memory_pool
`SQLMA_DBASE_ALL`	`get snapshot for all databases`	`SNAPDB`	dbase
		`ADMIN_GET_STORAGE_PATHS`	db_storage_group
			rollforward
			db_sto_path_info
		`SNAPTBSP`	tablespace
		`SNAPDB_MEMORY_POOL`	memory_pool
	`list active databases`		dbase
`SQLMA_DCS_DBASE`	`get snapshot for dcs database on dbname`		dcs_dbase, stmt_transmissions
`SQLMA_DCS_DBASE_ALL`	`get snapshot for all dcs databases`		dcs_dbase, stmt_transmissions
`SQLMA_DBASE_REMOTE`	`get snapshot for remote database on dbname`		dbase_remote
`SQLMA_DBASE_REMOTE_ALL`	`get snapshot for all remote databases`		dbase_remote
`SQLMA_APPL`	`get snapshot for application applid appl-id`	`SNAPAPPL`	appl
		`SNAPAGENT`	agent
		`SNAPAPPL_INFO`	appl_info
		`SNAPLOCKWAIT`	lock_wait
		`SNAPSTMT`	stmt
		`SNAPSUBSECTION`	subsection
		`SNAPAGENT_MEMORY_POOL`	memory_pool
`SQLMA_AGENT_ID`	`get snapshot for application agentid appl-handle`	`SNAPAGENT`	appl
		`SNAPAGENT`	agent
		`SNAPAPPL_INFO`	appl_info
		`SNAPLOCKWAIT`	lock_wait
		`SNAPSTMT`	stmt
		`SNAPSUBSECTION`	subsection
		`SNAPAGENT_MEMORY_POOL`	memory pool
`SQLMA_DBASE_APPLS`	`get snapshot for applications on dbname`	`SNAPAPPL`	appl
		`SNAPAGENT`	agent
		`SNAPAPPL_INFO`	appl_info
		`SNAPLOCKWAIT`	lock_wait
		`SNAPSTMT`	stmt
		`SNAPSUBSECTION`	subsection
		`SNAPAGENT_MEMORY_POOL`	memory_pool
`SQLMA_APPL_ALL`	`get snapshot for all applications`	`SNAPAPPL`	appl
		`SNAPAPPL_INFO`	appl_info
		`SNAPLOCKWAIT`	lock_wait
		`SNAPSTATEMENT`	stmt
		`SNAPAGENT`	agent
		`SNAPSUBSECTION`	subsection
		`SNAPAGENT_MEMORY_POOL`	memory_pool
`SQLMA_DCS_APPL`	`get snapshot for dcs application applid appl-id`		dcs_appl, dcs_stmt, dcs_appl_info, stmt_transmissions
`SQLMA_DCS_APPL_ALL`	`get snapshot for all dcs applications`		dcs_appl, dcs_stmt, dcs_appl_info, stmt_transmissions
`SQLMA_DCS_APPL_HANDLE`	`get snapshot for dcs application agentid appl-handle`		dcs_appl, dcs_stmt, dcs_appl_info, stmt_transmissions
`SQLMA_DCS_DBASE_APPLS`	`get snapshot for dcs applications on dbname`		dcs_appl, dcs_stmt, dcs_appl_info, stmt_transmissions
`SQLMA_DBASE_APPLS_REMOTE`	`get snapshot for remote applications on dbname`		dbase_appl
`SQLMA_APPL_REMOTE_ALL`	`get snapshot for all remote applications`		dbase_appl
`SQLMA_DBASE_TABLES`	`get snapshot for tables on dbname`	`SNAPTAB`	table
		`SNAPTAB_REORG`	table_reorg
			table_list
`SQLMA_APPL_LOCKS`	`get snapshot for locks for application applid appl-id`	`SNAPLOCK, SNAPAPPL, SNAPLOCKWAIT`	appl_lock_list, lock_wait, lock
`SQLMA_APPL_LOCKS_AGENT_ID`	`get snapshot for locks for application agentid appl-handle`	`SNAPLOCK, SNAPAPPL, SNAPLOCKWAIT`	appl_lock_list, lock_wait, lock
`SQLMA_DBASE_LOCKS`	`get snapshot for locks on dbname`	`SNAPLOCK`	appl_lock_list, lock
`SQLMA_DBASE_LOCKS`	`get snapshot for locks on dbname`	`SNAPLOCK, SNAPLOCKWAIT`	db_lock_list, lock_wait
`SQLMA_DBASE_TABLESPACES`	`get snapshot for tablespaces on dbname`	`SNAPTBSP`	tablespace
		`SNAPTBSPPART`	tablespace, tablespace_nodeinfo
		`SNAPTBSP_QUIESCER`	tablespace_quiescer, tablespace_nodeinfo
		`SNAPCONTAINER`	tablespace_container, tablespace_nodeinfo
		`SNAPTBSP_RANGE`	tablespace_ranges, tablespace_nodeinfo
			tablespace_list, tablespace_nodeinfo
`SQLMA_BUFFERPOOLS_ALL`	`get snapshot for all bufferpools`	`SNAPBP`	bufferpool
`SQLMA_DBASE_BUFFERPOOLS`	`get snapshot for bufferpools on dbname`	`SNAPBP`	bufferpool
`SQLMA_DYNAMIC_SQL`	`get snapshot for dynamic sql on dbname`	`SNAPDYN_SQL`	dynsql
`SQLMA_DYNAMIC_SQL`	`get snapshot for dynamic sql on dbname`		dynsql_list

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

Data stream hierarchy — Figure 1. Data Stream Hierarchy

Note: Times may be returned as part of any logical data grouping.