The following elements provide identification and status information about the database:
Snapshot Level Database Application Table Space Table Lock Dynamic SQL DCS Database DCS Application |
Logical Data Grouping dbase appl_id_info tablespace_header bufferpool table_header dbase_lock dynsql_list dcs_dbase dcs_appl_info |
Monitor Switch Basic Basic Buffer Pool Buffer Pool Table Basic Basic Basic Basic |
Resettable |
No | |
Event Type Database |
Logical Data Grouping dbheader_event | |
Element Name Element Type |
db_name information | |
| Related Information |
| |
Description: The real name of the database for which information is collected or to which the application is connected. This is the name the database was given when created.
Usage: You may use this element to identify the specific database to which the data applies.
For applications that are not using DB2 Connect to connect to a DRDA host database, you can use this element in conjunction with the "Database Path" monitor element to uniquely identify the database and help relate the different levels of information provided by the monitor.
Snapshot Level Database Application Table Space Table Lock Dynamic SQL |
Logical Data Grouping dbase appl_id_info tablespace_header bufferpool table_header dbase_lock dynsql_list |
Monitor Switch Basic Basic Buffer Pool Buffer Pool Table Basic Basic |
Resettable |
No | |
Event Type Database |
Logical Data Grouping dbheader_event | |
Element Name Element Type |
db_path information | |
| Related Information |
| |
Description: The full path of the location where the database is stored on the monitored system.
Usage: This element can be used with the "Database Name" monitor element to identify the specific database to which the data applies.
Snapshot Level Database Table Space Table |
Logical Data Grouping dbase tablespace_list table_list |
Monitor Switch Basic Buffer Pool Basic |
Resettable |
No |
|
Element Name Element Type |
db_conn_time timestamp | |
| Related Information |
| |
Description: The date and time of the connection to the database (at the database level, this is the first connection to the database), or when the activate database was issued.
Usage: Use this element with the "Database Deactivation Timestamp" monitor element to calculate the total connection time.
Event Type Database Connection |
Logical Data Grouping dbheader_event connheader_event |
|
Element Name Element Type |
conn_time timestamp | |
| Related Information |
| |
Description: The date and time of the connection to the database (at the database level, this is the first connection to the database), or when the activate database was issued.
Usage: Use this element with the "Database Deactivation Timestamp" monitor element to calculate the elapsed time since:
Event Type Database Connection |
Logical Data Grouping db_event conn_event |
|
Element Name Element Type |
disconn_time timestamp | |
| Related Information |
| |
Description: The date and time that the application disconnected from the database (at the database level, this is the time the last application disconnected).
Usage: Use this element to calculate the elapsed time since:
Snapshot Level Database |
Logical Data Grouping dbase |
Monitor Switch Basic |
Resettable |
No |
|
Element Name Element Type |
db_status information | |
| Related Information |
| |
Description: The current status of the database.
Usage: You can use this element to determine the state of your database.
Values for this field are:
| API Constant | Description |
|---|---|
| SQLM_DB_ACTIVE | The database is active. |
| SQLM_DB_QUIESCE_PEND | The database is in quiesce-pending state. New connections to the database are not permitted and new units of work cannot be started. Depending on the quiesce request, active units of work will be allowed to complete or will be rolled back immediately. |
| SQLM_DB_QUIESCED | The database has been quiesced. New connections to the database are not permitted and new units of work cannot be started. |
| SQLM_DB_ROLLFWD | A rollforward is in progress on the database. |
Snapshot Level Database |
Logical Data Grouping dbase |
Monitor Switch Basic |
Resettable |
No |
|
Event Type Database |
Logical Data Grouping db_event |
|
Element Name Element Type |
catalog_node_name information | |
| Related Information |
| |
Description: The network name of the catalog node. On OS/2, the netbios name of the server where the database is located.
Usage: Use this element to determine the location of a database.
| Note: | This element is similar to the node field in the sqlestat output. See Appendix D. DB2 Version 1 sqlestat Users for more information on sqlestat equivalent data elements. |
Snapshot Level Database |
Logical Data Grouping dbase |
Monitor Switch Basic |
Resettable |
No |
|
Element Name Element Type |
db_location information | |
| Related Information |
| |
Description: The location of the database in relation to the application.
Usage: Determine the relative location of the database server with respect to the application taking the snapshot. Values are:
| Note: | This element is similar to the location field in the sqlestat output. See Appendix D. DB2 Version 1 sqlestat Users for more information on sqlestat equivalent data elements. |
Snapshot Level Database |
Logical Data Grouping dbase |
Monitor Switch Basic |
Resettable |
No |
|
Event Type Database |
Logical Data Grouping db_event |
|
Element Name Element Type |
catalog_node information | |
| Related Information |
| |
Description: The node number of the node where the database catalog tables are stored.
Usage: The catalog node is the node where all system catalog tables are stored. All access to system catalog tables must go through this node. See the Administration Guide for information on system catalog tables.
Snapshot Level Database |
Logical Data Grouping dbase |
Monitor Switch Basic |
Resettable |
No |
|
Element Name Element Type |
last_backup timestamp | |
| Related Information |
| |
Description: The date and time that the latest database backup was completed.
Usage: You may use this element to help you identify a database that has not been backed up recently, or to identify which database backup file is the most recent. If the database has never been backed up, this timestamp is initialized to zero.