DB2 10.5 for Linux, UNIX, and Windows

TraceTime CLI/ODBC configuration keyword

Captures elapsed time counters in the trace file.

db2cli.ini keyword syntax:: TraceTime = 1 | 0
Default setting:: Elapsed time counters are included in the trace file.
Only applicable when:: the Trace option is turned on.
Usage notes:

When TraceTime is set to 1, elapsed time counters will be captured in the trace file. For example:

SQLPrepare( hStmt=1:1, pszSqlStr="SELECT * FROM ORG", cbSqlStr=-3 )
  ---> Time elapsed - +6.785751E+000 seconds ( StmtOut="SELECT * FROM ORG" )
SQLPrepare( )
  <--- SQL_SUCCESS Time elapsed - +2.527400E-002 seconds

Turn TraceTime off, by setting it to 0, to improve performance or to generate smaller trace files. For example:

SQLPrepare( hStmt=1:1, pszSqlStr="SELECT * FROM ORG", cbSqlStr=-3 )
( StmtOut="SELECT * FROM ORG" )
SQLPrepare( )
  <--- SQL_SUCCESS

This option is only used when the CLI/ODBC Trace option is turned on.

(This option is contained in the Common section of the initialization file and therefore applies to all connections to DB2®.)