Snapshot monitor interface mappings to logical data groups

Each individual API request type and CLP command 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 and CLP command listed in this table returns monitor elements from the logical data groups listed in the right-most column. 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 Logical data groups
SQLMA_APPLINFO_ALL list applications [show detail] appl_info
SQLMA_DBASE_APPLINFO list applications for database dbname [show detail] appl_info
SQLMA_DCS_APPLINFO_ALL list dcs applications [show detail] dcs_appl_info
SQLMA_DB2 get snapshot for dbm db2
fcm
fcm_node
utility_info
progress, progress_info
memory_pool
get dbm monitor switches switch_list
SQLMA_DBASE get snapshot for database on dbname dbase
detail_log
db_storage_group
rollforward

db_sto_path_info
tablespace
memory_pool
SQLMA_DBASE_ALL get snapshot for all databases dbase
db_storage_group
rollforward

db_sto_path_info
tablespace
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 appl
agent
appl_info
lock_wait
stmt
subsection
memory_pool
SQLMA_AGENT_ID get snapshot for application agentid appl-handle appl
agent
appl_info
lock_wait
stmt
subsection
memory pool
SQLMA_DBASE_APPLS get snapshot for applications on dbname appl
agent
appl_info
lock_wait
stmt
subsection
memory_pool
SQLMA_APPL_ALL get snapshot for all applications appl
appl_info
lock_wait
stmt
agent
subsection
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 table
table_reorg
table_list
SQLMA_APPL_LOCKS get snapshot for locks for application applid appl-id appl_lock_list, lock_wait, lock
SQLMA_APPL_LOCKS_AGENT_ID get snapshot for locks for application agentid appl-handle appl_lock_list, lock_wait, lock
SQLMA_DBASE_LOCKS get snapshot for locks on dbname appl_lock_list, lock
db_lock_list, lock_wait
SQLMA_DBASE_TABLESPACES get snapshot for tablespaces on dbname tablespace
tablespace, tablespace_nodeinfo
tablespace_quiescer, tablespace_nodeinfo
tablespace_container, tablespace_nodeinfo
tablespace_ranges, tablespace_nodeinfo
tablespace_list, tablespace_nodeinfo
SQLMA_BUFFERPOOLS_ALL get snapshot for all bufferpools bufferpool
SQLMA_DBASE_BUFFERPOOLS get snapshot for bufferpools on dbname bufferpool
SQLMA_DYNAMIC_SQL get snapshot for dynamic sql on dbname dynsql
dynsql_list
The following figure shows the order that logical data groupings may appear in a snapshot data stream.
Figure 1. Data Stream Hierarchy
Data stream hierarchy
Note: Times may be returned as part of any logical data grouping.