DB2 Version 9.7 for Linux, UNIX, and Windows

status_change_time - Application Status Change Time monitor element

The date and time the application entered its current status.

Element identifier
status_change_time
Element type
timestamp
Table 1. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Application appl_id_info Unit of Work, Timestamp
Lock appl_lock_list Unit of Work, Timestamp
DCS Application dcs_appl_info Unit of Work, Timestamp
Usage
This element allows you to determine how long an application has been in its current status. If it has been in the same status for a long period of time, this may indicate that it has a problem.
Parent topic: Database system monitor elements
Related reference:
appl_status - Application Status monitor element