Applications using either DB2 CLI or ODBC and the IBM DB2 CLI/ODBC Driver can have all the function calls traced to a plain text file. This can help with problem determination, datababase and application tuning or just to better understand what a 3rd party application is doing.
The trace can be enabled at runtime using the CLI/ODBC Settings notebook, accessible from the Client Configuration Assistant if it is available, or by editing the db2cli.ini file directly. A DB2 CLI application can also enable the trace by setting the SQL_ATTR_TRACE and SQL_ATTR_TRACEFILE Environment or Connection attributes. These are the same attributes used by the tracing facility in the Microsoft ODBC Driver Manager.