Performance Metric kcml.odbc.execute

Summary

Execution of SQL plan

Send Condition

Sent when an SQL plan is executed by kiodbc

Overview

Measures the time taken to execute an SQL query. This includes time taken to retrieve data from the database which can be determined by use of the kcml.kdb.fetch metric.

Statistics

NameTypeDescription
plannumSQL plan
handlenumTable/query handle
chandlenumConnection handle
timeusecTotal time taken to execute
reclennumSize of a record in the result set
errnumDatabase error code

General Form

kcml.odbc.execute,plan=num,handle=num,chandle=num,time=usec,reclen=num,err=num

See Also:

Performance Metrics