DB2 Version 9.7 for Linux, UNIX, and Windows

total_exec_time - Elapsed statement execution time monitor element

The total time in seconds and microseconds that was spent executing a particular statement in the SQL cache.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Dynamic SQL	dynsql	Statement

For snapshot monitoring, this counter can be reset.

Usage

Use this element with num_executions monitor element determine the average elapsed time for the statement and identify the SQL statements that would most benefit from a tuning of their SQL. The num_compilation monitor element must be considered when evaluating the contents of this element.

Note: Due to the differences in granularity with which the DB2 system collects statistics, the value of the total_exec_time monitor element might not equal the sum of values of system_cpu_time and user_cpu_time monitor elements. In this case, the sum of system_cpu_time and user_cpu_time monitor elements more accurately reflects the actual total execution time.