DB2 Version 9.7 for Linux, UNIX, and Windows

TraceFlushOnError CLI/ODBC configuration keyword

Specifies whether all CLI/ODBC trace entries are written to disk when an error occurs.

db2cli.ini keyword syntax:: TraceFlushOnError = 0 | 1
Default setting:: Do not write CLI/ODBC trace entries as soon as an error occurs.
Only applicable when:: the CLI/ODBC Trace option is turned on.
Usage notes:

Setting TraceFlushOnError=1 forces the CLI driver to close and re-open the trace file each time an error is encountered. If TraceFlushOnError is left at its default value of 0, then trace file will only be closed when the application terminates normally or the interval specified by the TraceFlush keyword is reached. If the application process were to terminate abnormally when TraceFlushOnError=0, then valuable trace information may be lost. Setting TraceFlushOnError=1 may impact performance, but will ensure that trace entries associated with errors are written to disk.

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

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