
B-1
A P P E N D I X B
Troubleshooting
What’s in this appendix
ODBC Debug Logging and Driver Manager Tracing
JDBC Debug Logging
OLE DB Debug Logging
This appendix introduces methods for tracking system activity, which can help in detecting
problems and troubleshooting issues. A debug log provides you with a record of system
activity, so you can take steps to correct problems.
ODBC Debug Logging and Driver Manager Tracing
This section discusses the procedures for enabling debug logging and driver manager trac-
ing, two methods of tracking system activity. Netezza recommends you use debug logging,
which provides the necessary information and is a supported driver logging function. Trac-
ing is an external, non-Netezza driver manager option that keeps a log of function calls
between the driver manager and the driver, and between the driver manager and the appli-
cation. Both debugging and tracing are disabled by default and should be enabled only for
troubleshooting, as they may degrade the client application performance.
ODBC Debug Logging
By default, debug logging is disabled, as enabling may affect performance.
Enabling ODBC Logging in Windows
Use the following steps to enable ODBC Logging in Windows.
1. Open the ODBC Data Source Administrator window:
Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC)
2. In the ODBC Data Source Administrator window, select the System DSN tab.
3. Select the NZSQL system data source and click Configure.
4. Select the Driver Options tab.
5. Select Enable Debug Logging.
6. Specify the Log File Path, where the ODBC log will be saved. The log file name is
nzodbc_<user><pid>.log.
Comentários a estes Manuais