Resolution:
Description:
=========
How to enable ODBC trace for certain services of TIBCO ActiveMatrix® Adapter for Database.

Environment:
==========
UNIX only
Adapter version v5.x and v6.x

Resolution:
=========
To enable ODBC trace for certain adapter services, you need to provide a separate odbc.ini file for this service. Here are the steps:

1). Copy odbc.ini from &ltadb_home>/odbc/odbc.ini, rename it, ie, "odbc.t.ini"
Enable odbc trace in odbc.t.ini by modifying the following properties:

Trace=1
TraceFile=odbctrace.out &ltprovide the path where you want to put the odbc trace>

2). Copy adbagent_env.sh in &ltadb_home>/bin, rename it, i.e., "adbagent_env.t.sh",
Modify the following line to point to the one we modified, for example:

ODBCINI=/home/adb/tibco/adapter/adadb/6.0/odbc/odbc.t.ini
export ODBCINI

3). Go to the deployed adapter service folder which is usually in

&ltdomain_home>/application/&ltapplication_name>

a). Open the .sh file, replace "adbagent_env.sh" with "adbagent_env.t.sh"
b). Open the .tra file, modify the following ODBC variable, i.e.,
tibco.env.ODBCINI /home/adb/tibco/adapter/adadb/6.0/odbc/odbc.t.ini

4). Start the adapter service. The service will start with ODBC trace enabled. The trace file will be located under &ltTraceFile>. If only the file name is provided, the file will be found in the folder where the service was started.

Enabling ODBC trace for certain services of TIBCO ActiveMatrix® Adapter for Database.