The following table lists the Snapshot request types and the logical data
groupings that can be returned. Figure 6 shows the hierarchical structure of the logical data
groups.
| API request type | Logical data groupings that may be returned | Information returned |
|---|---|---|
All Snapshots |
collected (SQLM_ELM_COLLECTED) | Information relevant to the entire snapshot. Including an indication of the number of lower level logical data groups that follow. |
| SQLMA_DB2 |
db2 (SQLM_ELM_DB2) fcm (SQLM_ELM_FCM) fcm_node (SQLM_ELM_FCM_NODE) |
DB2 instance information. FCM information. FCM node information. |
SQLMA_APPLINFO_ALL SQLMA_DBASE_APPLINFO |
appl_info (SQLM_ELM_APPL_INFO) | Application identification information. |
SQLMA_DCS_APPLINFO_ALL |
dcs_appli_info (SQLM_ELM__DCS_APPL_INFO) | DCS application identification information. |
SQLMA_DCS_APPL SQLMA_DCS_APPL_HANDLE SQLMA_DCS_DBASE_APPLS |
dcs_appl (SQLM_ELM_DCS_APPL) dcs_stmt (SQLM_ELM_DCS_STMT) dcs_appl_info (SQLM_ELM_DCS_APPL_INFO) |
DCS application information. DCS statement information. DCS application identification information. |
SQLMA_APPL SQLMA_AGENT_ID SQLMA_DBASE_APPLS |
appl (SQLM_ELM_APPL) agent (SQLM_ELM_AGENT) appl_info (SQLM_ELM_APPL_INFO) lock_wait (SQLM_ELM_LOCK_WAIT) stmt (SQLM_ELM_STMT) subsection (SQLM_ELM_SUBSECTION) agent (SQLM_ELM_AGENT) |
Application information. Agent information. Application information. Lock waiting information. Statement information. Subsection information. Subagent information for parallel SQL processing in partitioned databases and on SMP machines. |
SQLMA_DCS_DBASE SQLMA_DCS_DBASE_ALL |
dcs_dbase (SQLM_ELM_DCS_DBASE) | DCS database information. |
SQLMA_DBASE SQLMA_DBASE_ALL |
dbase (SQLM_ELM_DBASE) rollforward (SQLM_ELM_ROLLFORWARD) tablespace (SQLM_ELM_TABLESPACE) |
Database information. Rollforward information. Tablespace information |
SQLMA_DBASE_TABLES |
table_list (SQLM_ELM_TABLE_LIST) tables (SQLM_ELM_TABLE) |
Table information. Database-wide table information. |
SQLMA_APPL_LOCKS SQLMA_APPL_LOCKS_AGENT_ID |
appl_lock_list (SQLM_ELM_APPL_LOCK_LIST) lock_wait (SQLM_ELM_LOCK_WAIT) lock (SQLM_ELM_LOCK) |
A listing of application locks. If any lock waits, they precede locks. Lock information. |
SQLMA_DBASE_LOCKS |
db_lock_list (SQLM_ELM_DB_LOCK_LIST) lock_wait (SQLM_ELM_LOCK_WAIT) lock (SQLM_ELM_LOCK) appl_lock_list (SQLM_ELM_APPL_LOCK_LIST) |
A listing of database locks. If any lock waits, they preceed locks. Lock information. A listing of application locks. |
| SQLMA_DBASE_TABLESPACES |
tablespace_list (SQLM_ELM_TABLESPACE_LIST) tablespace (SQLM_ELM_TABLESPACE) |
Database-wide tablespace information. Tablespace information. |
SQLMA_BUFFERPOOLS_ALL SQLMA_DBASE_BUFFERPOOLS |
bufferpool (SQLM_ELM_BUFFERPOOL) | Buffer pool information. |
SQLMA_DYNAMIC_SQL |
dysql_list (SQLM_ELM_DYNSQL_LIST) dysql (SQLM_ELM_DYNSQL) |
List of dynamic SQL statements. Dynamic SQL statement information. |
The following figure shows the order that logical data groupings may appear in a snapshot data stream.
Figure 6. Data Stream Hierarchy
|
| Note: | Times may be returned as part of any logical data grouping. |