LogLevel

Default Value Data Type Required

None

Integer or String

No

Description

Use this property to enable or disable logging in the connector and to specify the amount of detail included in log files.

Important:

Important:

Only enable logging long enough to capture an issue. Logging decreases performance and can consume a large quantity of disk space.

Set the property to one of the following numbers:

  • 0: Disable all logging.
  • 1: Enable logging on the FATAL level, which logs very severe error events that will lead the connector to abort.
  • 2: Enable logging on the ERROR level, which logs error events that might still allow the connector to continue running.
  • 3: Enable logging on the WARNING level, which logs events that might result in an error if action is not taken.
  • 4: Enable logging on the INFO level, which logs general information that describes the progress of the connector.
  • 5: Enable logging on the DEBUG level, which logs detailed information that is useful for debugging the connector.
  • 6: Enable logging on the TRACE level, which logs all connector activity.

When logging is enabled, the connector produces the following log files in the location specified in the LogPath property:

  • A RedshiftJDBC_driver.log file that logs connector activity that is not specific to a connection.
  • A Simba Amazon Redshift JDBC Driver_connection_[Number].log and Simba Amazon Redshift JDBC Driver_connection_ext_[Number].log file for each connection made to the database, where [Number] is a number that identifies each log file. These files log connector activity that is specific to the connection.

If the LogPath value is invalid, then the connector sends the logged information to the standard output stream (System.out).