System Monitor Guide and Reference

Database Identification and Status

The following elements provide identification and status information about the database:

Database Name
Database Path
Database Activation Timestamp
Time of Database Connection
Database Deactivation Timestamp
Status of Database
Catalog Node Network Name
Database Location
Catalog Node Number
Last Backup Timestamp

Database Name

Snapshot Level Database Application Table Space Table Lock Dynamic SQL DCS Database DCS Application	Logical Data Grouping dbase dbase_remote appl_id_info appl_remote tablespace_header bufferpool table_header dbase_lock dynsql_list dcs_dbase dcs_appl_info	Monitor Switch Basic Basic 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	"Resetting Monitor Data" "Last Reset Timestamp" "Input Database Alias" "Database Alias Used by Application" "Database Path"

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.

Database Path

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	"Resetting Monitor Data" "Input Database Alias" "Database Name"

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.

Database Activation Timestamp

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	"Connection Request Start Timestamp" "Snapshot Time" "Time of Database Connection"

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.

Time of Database Connection

Event Type Database Connection	Logical Data Grouping dbheader_event connheader_event
Element Name Element Type	conn_time timestamp
Related Information	"Database Activation Timestamp" "Database Deactivation Timestamp"

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:

The database was active (for information at the database level)
The connection was active (for information at the connection level).

Database Deactivation Timestamp

Event Type Database Connection	Logical Data Grouping db_event conn_event
Element Name Element Type	disconn_time timestamp
Related Information	None

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:

The database was active (for information at the database level)
The connection was active (for information at the connection level).

Status of Database

Snapshot Level Database	Logical Data Grouping dbase	Monitor Switch Basic
Resettable	No
Element Name Element Type	db_status information
Related Information	"Status of DB2 Instance"

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.

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.

Catalog Node Network Name

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	None

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.

Database Location

Snapshot Level Database	Logical Data Grouping dbase	Monitor Switch Basic
Resettable	No
Element Name Element Type	db_location information
Related Information	"Server Operating System"

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:

SQLM_LOCAL
SQLM_REMOTE

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.

Catalog Node Number

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	None

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.

Last Backup Timestamp

Snapshot Level Database	Logical Data Grouping dbase	Monitor Switch Basic
Resettable	No
Element Name Element Type	last_backup timestamp
Related Information	None

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.

[ Top of Page | Previous Page | Next Page ]