IBM Books

Type of Snapshot Monitor Data


Snapshot Information Level
Database Manager
 
 
Database
 
Table Space
 
 
 
 
Table
 
Application
 
 
 
 
DCS Application
Lock

API Structure(s)
sqlm_db2
sqlm_fcm
sqlm_fcm_node
sqlm_dbase
sqlm_dbase_lock
sqlm_tablespace
sqlm_tablespace_header
sqlm_rollfwd_info
sqlm_rollfwd_ts_info
sqlm_bufferpool
sqlm_table
sqlm_table_header
sqlm_appl
sqlm_applinfo
sqlm_appl_lock
sqlm_subagent
sqlm_subsection
sqlm_dcs_applinfo
sqlm_lock

Monitor Group
Basic
Basic
Basic
Basic
Basic
Basic
Basic
Basic
Basic
Basic
Basic
Basic
Basic
Basic
Basic
Basic
Basic
Basic
Basic

Resettable

No

 

API Element Name
Element Type

info_type
information

 

Description:  The type of snapshot record returned by the database system monitor.

Usage:  Applications that read database system monitor information should always use this field to determine the type of information that is being returned and to determine which API structure to use. The following table shows the API constants and the snapshot monitor data structure that should be used when interpreting the record.

API Constant
API Data Structure
SQLM_DB2_SS
sqlm_db2
SQLM_DBASE_SS
sqlm_dbase
SQLM_DBASE_LOCK_SS
sqlm_dbase_lock
SQLM_APPL_SS
sqlm_appl
SQLM_APPLINFO_SS
sqlm_applinfo
SQLM_DCS_APPLINFO_SS
sqlm_dcs_applinfo
SQLM_TABLE_HEADER_SS
sqlm_table_header
SQLM_TABLE_SS
sqlm_table
SQLM_APPL_LOCK_SS
sqlm_appl_lock
SQLM_LOCK_SS
sqlm_lock
SQLM_TABLESPACE_HEADER_SS
sqlm_tablespace_header
SQLM_TABLESPACE_SS
sqlm_tablespace

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]