ODBC trace

You can use various methods to trace for ODBC activity, depending on the operating system that you are using.

About this task

For Windows, use the Tracing tab of the ODBC function:

1. Click Start > Settings > Control Panel > Administrative Tools.
2. Double-click Data Sources.
3. Click the Tracing tab.
4. Click Start Tracing Now.
5. Click OK.

To stop ODBC tracing, on the Tracing tab, click Stop Tracing Now, then OK.

For Linux® and UNIX operating systems using IBM® Integration ODBC Database Extender drivers:

• To initiate trace for ODBC activity, edit the [ODBC] stanza in the odbcinst.ini file in the directory pointed to by your ODBCSYSINI environment variable as follows:
  1. Change Trace=no to Trace=yes.
  2. Specify a path and file name for TraceFile
  3. Ensure that the TraceFile entry points to a file system that has enough space to receive the trace output