15.10 - DSN Tracing Attributes - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

ODBC Driver for Teradata
User Guide

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.


Table 24: Data Source Name Tracing 



DSNTraceEnable=[Yes | No]

Enables DSN tracing.

  • No (default) - disabled
  • Yes - enabled
  • If the specification is missing, tracing is not activated for any connection that uses the DSN.


    Specifies the threshold for deleting the contents of the DSN trace file.

    Default is 2000000000 (2,000,000,000 bytes).


    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.


    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.

  • No (default) - When opened, the trace file is appended to the existing file.
  • Yes - When opened, the trace file is overwritten. The file is effectively deleted and opened as a new file.
  • DSNTraceLineNumbers=[Yes | No]

    Specifies whether file names and line numbers are appended to each trace entry.

  • No - Produces a trace file without file names and line numbers.
  • Yes - (default) Adds file names and line numbers.
  • Important: Using any of the tracing options can significantly degrade performance.