Configuring Logging Options
To help troubleshoot issues, you can enable logging. In addition to functionality provided in the Simba Amazon Redshift ODBC Connector, the ODBC Data Source Administrator provides tracing functionality.
Important:
Only enable logging or tracing long enough to capture an issue. Logging or tracing decreases performance and can consume a large quantity of disk space.
Configuring Connector-wide Logging Options
The settings for logging apply to every connection that uses the Simba Amazon Redshift ODBC Connector, so make sure to disable the feature after you are done using it.
To enable connector-wide logging:
- To access logging options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Logging Options.
- From the Log Level drop-down list, select the logging level corresponding to the amount of information that you want to include in log files:
- In the Log Path field, specify the full path to the folder where you want to save log files.
- Click OK.
- Restart your ODBC application to make sure that the new settings take effect.
Logging Level | Description |
---|---|
OFF |
Disables all logging. |
FATAL |
Logs severe error events that lead the connector to abort. |
ERROR |
Logs error events that might allow the connector to continue running. |
WARNING |
Logs events that might result in an error if action is not taken. |
INFO |
Logs general information that describes the progress of the connector. |
DEBUG |
Logs detailed information that is useful for debugging the connector. |
TRACE |
Logs all connector activity. |
The Simba Amazon Redshift ODBC Connector produces the following log files at the location you specify in the Log Path field:
- A
redshiftodbcdriver.log
file that logs connector activity that is not specific to a connection. - A
redshiftodbcdriver_connection_[Number].log
file for each connection made to the database, where [Number] is a number that identifies each log file. This file logs connector activity that is specific to the connection.
If you enable the UseLogPrefix
connection property, the connector prefixes the log file name with the user name associated with the connection and the process ID of the application through which the connection is made. For more information, see UseLogPrefix on page 1.
To disable connector logging:
- Open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Logging Options.
- From the Log Level drop-down list, select LOG_OFF.
- Click OK.
- Restart your ODBC application to make sure that the new settings take effect.
- Driver Logging Configuration Options on page 1
- Creating a Data Source Name