快照监视器接口至逻辑数据组的映射
每个单独的 API 请求类型和 CLP 命令仅从所有逻辑数据组的某个子集捕获监视数据。
下表列示用来访问快照监视数据的一些方法。所有快照监视数据都存储在监视元素中，这些监视元素按逻辑数据组分类。此表中列示的每个单独
API 请求类型和 CLP 命令都会从最右列中列示的逻辑数据组返回监视元素。
仅当关联监视开关设置为 ON 时，才返回某些监视元素。请参阅各个监视元素以确定所需的元素是否在开关控制之下。
| db2GetSnapshot API 请求类型 | CLP 命令 | 逻辑数据组 |
|---|---|---|
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 |
下图显示逻辑数据分组在快照数据流中可能出现的顺序。图 1. 数据流层次结构
注： 时间可能作为任何逻辑数据分组的一部分返回。