You must create at least one DSN before you can control tracing. To control tracing for a DSN, the odbc.ini file might contain the additional entries listed in Table 24 within a Data Source Specification or Default Data Source Specification section.
Keyword |
Description |
DSNTraceEnable=[Yes | No] |
Enables DSN tracing. If the specification is missing, tracing is not activated for any connection that uses the DSN. |
DSNTraceFileFlushThreshold= |
Specifies the threshold for deleting the contents of the DSN trace file. Default is 2000000000 (2,000,000,000 bytes). |
DSNTraceFilePath=<path> |
Specifies the relative or absolute path of the trace file. Default is /tmp/ODBC.Trace.xxxxx. If the entry is missing, a default pathname of /tmp/ODBC.Trace.xxxxx is used, where xxxxx is the pid of the creating process. |
DSNTraceFileMaxSize=<size> |
Specifies the maximum size of the trace file. Default is 1000000 (1,000,000 bytes). Size must be between 10,000 and 1,000,000,000. If this entry is missing, a default size of 1,000,000 bytes is assumed. |
DSNTraceOverwrite=[Yes | No] |
Specifies whether the trace file is overwritten when it is first opened. |
DSNTraceLineNumbers=[Yes | No] |
Specifies whether file names and line numbers are appended to each trace entry. |
Important: Using any of the tracing options can significantly degrade performance.