Redrive Support

Redrive is a Teradata Database feature that enables applications to reconnect to the database and resume any interrupted activity after a network error, database failure, or database restart occurs. When connected to a database that has Redrive enabled, the Simba Teradata ODBC Connector can use this feature to reconnect to the database and resume queries after an interruption.

Note:

For information about configuring Redrive in the database, see "Redrive Protection for Queries" in Teradata Database Administration: https://docs.teradata.com/reader/B7Lgdw6r3719WUyiCSJcgw/tGnoclQ5P79MZYUu52NDdw.

To configure the connector to use Redrive, set the following properties in your DSN or connection string:

When you connect to the database with Redrive enabled, you have the option of overriding these connection-level settings to enable or disable this feature on the statement level. To do this, set the SQL_ATTR_REDRIVE(13014) statement attribute to one of the following values:

  • SQL_REDRIVE_OFF(0) to disable Redrive for the current statement.
  • SQL_REDRIVE_ON(1) to enable Redrive for the current statement.
    Note:

    You cannot enable Redrive on the statement level if the feature is disabled on the connection level.