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"
"Database Deactivation Timestamp"
"Status of Database"
"Catalog Node Network Name"
"Database Location"
"Catalog Node Number"
"Last Backup Timestamp"

Database Name

Snapshot Information Level Database Application Table Space Table Lock DCS Application	API Structure(s) sqlm_dbase sqlm_appl_id_info sqlm_tablespace_header sqlm_bufferpool sqlm_table_header sqlm_dbase_lock sqlm_dcs_applinfo	Monitor Switch Basic Basic Buffer Pool Buffer Pool Table Basic Basic
Resettable	No
Event Type Database	Event Record(s) sqlm_dbheader_event
API 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 DDCS 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.

If you are using the database system monitor APIs, note that the API constant SQLM_IDENT_SZ is used to define the length of this element. Only the first 8 characters are currently used for DB2 databases, and the first 18 characters are used for DRDA host databases.

Database Path

Snapshot Information Level Database Application Table Space Table Lock	API Structure(s) sqlm_dbase sqlm_appl_id_info sqlm_tablespace_header sqlm_bufferpool sqlm_table_header sqlm_dbase_lock	Monitor Switch Basic Basic Buffer Pool Buffer Pool Table Basic
Resettable	No
Event Type Database	Event Record(s) sqlm_dbheader_event
API 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 Information Level Database Table Space Table	API Structure(s) sqlm_dbase sqlm_tablespace_header sqlm_table_header	Monitor Switch Basic Buffer Pool Basic
Resettable	No
Event Type Database Connection	Event Record(s) sqlm_db_event sqlm_dbheader_event sqlm_connheader_event
API Element Name Element Type	db_conn_time conn_time timestamp
Related Information	"Resetting Monitor Data" "Connection Request Start Timestamp" "Snapshot Time"

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.

Database Deactivation Timestamp

Event Type Database Connection	Event Record(s) sqlm_db_event sqlm_conn_event
API 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 Information Level Database	API Structure(s) sqlm_dbase	Monitor Switch Basic
Resettable	No
API 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 Information Level Database	API Structure(s) sqlm_dbase	Monitor Switch Basic
Resettable	No
Event Type Database	Event Record(s) sqlm_db_event
API 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 C. "DB2 Version 1 sqlestat Users" for more information on sqlestat equivalent data elements.

Database Location

Snapshot Information Level Database	API Structure(s) sqlm_dbase	Monitor Switch Basic
Resettable	No
API 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 C. "DB2 Version 1 sqlestat Users" for more information on sqlestat equivalent data elements.

Catalog Node Number

Snapshot Information Level Database	API Structure(s) sqlm_dbase	Monitor Switch Basic
Resettable	No
Event Type Database	Event Record(s) sqlm_db_event
API 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 Information Level Database	API Structure(s) sqlm_dbase	Monitor Switch Basic
Resettable	No
API 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 | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]