How to enable trace for ADS ODBC driver from a Linux/Unix Client

How to enable trace for ADS ODBC driver from a Linux/Unix Client

book

Article ID: KB0081310

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization v6.2

Description

How to enable trace for ADS ODBC driver from a Linux/Unix Client for versions v6.2 and earlier.
(for odbc version 7.0.x, please see Knowledge Base article #
000036402)

Issue/Introduction

How to enable trace for ADS ODBC driver from a Linux/Unix Client, version 6.2 and earlier.

Resolution

After you've configured a dsn on your linux client, look for this file: <Composite_Home>/compositeXX.xml (filename will vary based on the version of composite)
To enable debugging, edit this file and add one of these options to the host element for the DSN you want to debug:
 
traceLevel="debug"
OR
traceLevel="info"

 
debug gives you full verbosity protocol level details.
info gives you all the ODBC calls made on the driver without the protocol level info.
 
Here's an example of a trace-enabled dsn entry in the compositeXX.xml
file:
<connection name="my_test">

<driver name="Composite 5.0" version="5.0.0.0" /> <host name="localhost"

port="9401" uid="test"

password="5EA27D000D0AB84D"

datasource="ds"

catalog="cat"

domain="composite" traceLevel="debug" /> </connection>
 
Note: The string traceLevel is case sensitive.
After making a client connection through this dsn, a new file
CsOdbcDebug.txt file appears in your <Composite_Home> directory.