DSN Tracing Attributes - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
smj1488824663219.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 the following table within a Data Source Specification or Default Data Source Specification section.

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.