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®.)