Configuring Logging Options

To help troubleshoot issues, you can enable logging. In addition to functionality provided in the Simba Apache Spark 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 Apache Spark ODBC Connector, 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.

  3. In the Log Path field, specify the full path to the folder where you want to save log files.
  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. Click OK.
  7. Restart your ODBC application to make sure that the new settings take effect.

The Simba Apache Spark ODBC Connector produces the following log files at the location you specify in the Log Path field:

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

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