DB2 Version 9.7 for Linux, UNIX, and Windows

act_exec_time - Activity execution time monitor element

Time spent executing at this partition, in microseconds. For cursors, the execution time is the combined time for the open, the fetches, and the close. The time when the cursor is idle is not counted towards execution time. For routines, execution time is the start to end of routine invocation. The lifetimes of any cursors left open by routine (to return a result set) after the routine finishes are not counted towards the routine execution time. For all other activities, execution time is the difference between start time and stop time. In all cases, execution time does not include time spent initializing or queued.

Table 1. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Activities	event_activity	-

Usage

This element can be used alone to know the elapsed time spent executing the activity by DB2® on each partition. This element can also be used together with time_started and time_completed monitor elements on the coordinator partition to compute the idle time for cursor activities. You can use the following formula:

Cursor idle time = (time_completed - time_started) - act_exec_time