ODBC problem isolation
Use this information to isolate problems with ODBC.
Communications
Use the cwbping program to verify the connection between the Linux® workstations and the iSeries™ server, and to verify the host servers are started.
Tracing and Logging
Once you verify your connection to the server, there see the following trace files for problem isolation:
- SQL log. The unixODBC sql.log will show the input and output parameters for ODBC API calls made. The sql.log is activated using the unixODBC ODBCConfig program. From the Advanced tab, you can enable sql tracing and configure the location of the log file.
- History log. The history log will show high-level communication, security and data conversion error messages. The History log is activated using the cwbtrc program.
- Detail trace. The detail trace will show low-level driver information and is intended for use in reporting problems to IBM®. Detail trace is activated using the cwbtrc program.
- Service information collection tool. The service information collection tool is intended for use in reporting problems to IBM. The service information collection tool is activated using the cwbmedic program.
Parent topic:
Troubleshoot an iSeries Access for Linux ODBC
Related reference
CWBMEDIC - Service information collection tool
CWBPING - Test the connection to the server
CWBTRC - Trace iSeries Access for Linux