Configuring Logging Options

To help troubleshoot issues, you can enable logging. In addition to functionality provided in the Simba Athena ODBC Driver, the ODBC Data Source Administrator provides tracing functionality.

Important:

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 Athena ODBC Driver, so make sure to disable the feature after you are done using it. To configure logging for the current connection, see Configuring Logging for the Current Connection.

To enable connector-wide logging:

  1. 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.
  2. 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:
    3. 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.

    Note:

    If the Use AWS Logger check box is selected, the connector also logs information from AWS API calls.

  3. In the Log Path field, specify the full path to the folder where you want to save log files. You can type the path into the field, or click Browse and then browse to select the folder.
  4. In the Max Number Files field, type the maximum number of log files to keep.

    5. Note:

    After the maximum number of log files is reached, each time an additional file is created, the connector deletes the oldest log file.

  5. In the Max File Size field, type the maximum size of each log file in megabytes (MB).

    6. Note:

    After the maximum file size is reached, the connector creates a new file and continues logging.

  6. To log information about AWS API calls, select the Use Aws Logger check box.
  7. Click OK.
  8. Restart your ODBC application to make sure that the new settings take effect.

The Simba Athena ODBC Driver produces the following log files at the location you specify in the Log Path field:

  • A simbaathenaodbcdriver.log file that logs connector activity that is not specific to a connection.
  • A simbaathenaodbcdriver_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.

To disable connector logging:

  1. Open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Logging Options.
  2. From the Log Level drop-down list, select LOG_OFF.
  3. Click OK.
  4. Restart your ODBC application to make sure that the new settings take effect.

Related topics