15.10 - DSN Tracing Attributes - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

prodname
ODBC Driver for Teradata
vrm_release
15.10
category
User Guide
featnum
B035-2509-035K

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 

Keyword

Description

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.

    DSNTraceFileFlushThreshold=
    <size>

    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.

  • 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.