ODBC trace types

Db2 ODBC provides two traces that differ in purpose: an application trace for debugging user applications, and a service trace for problem diagnosis.

Application trace
You can enable Db2 ODBC application trace by using the APPLTRACE and APPLTRACEFILENAME keywords in the Db2 ODBC initialization file.
ODBC diagnostic trace
The diagnostic trace captures information to use in Db2 ODBC problem determination. Use this trace only under the direction of IBM® Support. This trace is not intended to assist in debugging user-written Db2 ODBC applications.
Stored procedure trace
To obtain an application trace or a diagnostic trace of a Db2 ODBC stored procedure, you need to perform certain steps in the initialization file.

Parent topic: Problem diagnosis