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 (COLLECTED) | Information relevant to the entire snapshot. Including an indication of the number of lower level logical data groups that follow. |
| SQLMA_DB2 |
db2 (DB2) fcm (FCM) fcm_node (FCM_NODE) |
DB2 instance information. FCM information. FCM node information. |
|
SQLMA_APPLINFO_ALL SQLMA_DBASE_APPLINFO |
appl_info (APPL_INFO) | Application identification information. |
|
SQLMA_DCS_APPLINFO_ALL |
dcs_appli_info (_DCS_APPL_INFO) | DCS application identification information. |
|
SQLMA_DCS_APPL SQLMA_DCS_APPL_HANDLE SQLMA_DCS_DBASE_APPLS |
dcs_appl (DCS_APPL) dcs_stmt (DCS_STMT) dcs_appl_info (DCS_APPL_INFO) |
DCS application information. DCS statement information. DCS application identification information. |
|
SQLMA_APPL SQLMA_AGENT_ID SQLMA_DBASE_APPLS |
appl (APPL) agent (AGENT) appl_info (APPL_INFO) lock_wait (LOCK_WAIT) stmt (STMT) subsection (SUBSECTION) agent (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 (DCS_DBASE) | DCS database information. |
|
SQLMA_DBASE SQLMA_DBASE_ALL |
dbase (DBASE) rollforward (ROLLFORWARD) tablespace (TABLESPACE) |
Database information. Rollforward information. Tablespace information |
|
SQLMA_DBASE_TABLES |
table_list (TABLE_LIST) tables (TABLE) |
Table information. Database-wide table information. |
|
SQLMA_APPL_LOCKS SQLMA_APPL_LOCKS_AGENT_ID |
appl_lock_list (APPL_LOCK_LIST) lock_wait (LOCK_WAIT) lock (LOCK) |
A listing of application locks. If any lock waits, they precede locks. Lock information. |
|
SQLMA_DBASE_LOCKS |
db_lock_list (DB_LOCK_LIST) lock_wait (LOCK_WAIT) lock (LOCK) appl_lock_list (APPL_LOCK_LIST) |
A listing of database locks. If any lock waits, they precede locks. Lock information. A listing of application locks. |
| SQLMA_DBASE_TABLESPACES |
tablespace_list (TABLESPACE_LIST) tablespace (TABLESPACE) |
Database-wide tablespace information. Tablespace information. |
|
SQLMA_BUFFERPOOLS_ALL SQLMA_DBASE_BUFFERPOOLS |
bufferpool (BUFFERPOOL) | Buffer pool information. |
|
SQLMA_DYNAMIC_SQL |
dysql_list (DYNSQL_LIST) dysql (DYNSQL) |
List of dynamic SQL statements. Dynamic SQL statement information. |
|
SQLMA_DBASE_REMOTE SQLMA_DBASE_REMOTE_ALL |
dbase_remote (DBASE_REMOTE) | Federated system database information. |
|
SQLMA_DBASE_APPLS_REMOTE SQLMA_APPL_REMOTE_ALL |
dbase_appl (DBASE_APPL) | Federated system application 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. |