IBM Books

Statement Operation Stop Timestamp


Snapshot Information Level
Application

API Structure(s)
sqlm_appl
sqlm_stmt

Monitor Group
Statement
Statement

Resettable

No 

 

Event Information Level
Statement

API Structure(s)
sqlm_stmt_event

  

API Element Name
 
Element Type

stmt_stop (Snapshot)
stop_time (event)
Timestamp

 

Description:  The date and time when the "Statement Operation" stopped executing.

Usage:  You can use this element with "Statement Operation Start Timestamp" to calculate the elapsed statement operation execution time.

For a FETCH statement from an event monitor, this is the time of the last successful fetch.

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

[ DB2 List of Books | Search the DB2 Books ]