IBM Books

First Database Connect Timestamp


Snapshot Information Level
Database
Table Space
Table

API Structure(s)
sqlm_dbase
sqlm_tablespace_header
sqlm_table_header

Monitor Group
Basic
Buffer Pool
Basic

Resettable

No

 

Event Information Level
Database

API Structure(s)
sqlm_db_event

 

API Element Name
Element Type

db_conn_time
timestamp

 

Description:  Provides the earliest "Connection Request Start Timestamp" for the database.

Usage:  You may use this element in conjunction with "Timestamp" to calculate the database connection elapsed time.

This timestamp will be reset when the last application disconnects from the database.

Equivalent information for table space and table levels of the event monitor can be obtained using "Time of Database Connection".

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

[ DB2 List of Books | Search the DB2 Books ]