SSIS Components for Teradata

Build 24.0.9060

RecoveryStartInterval

The starting time interval (in seconds) after which an attempt to retry a reconnection is performed.

Data Type

int

Default Value

2

Remarks

This is the first time period to wait between unsuccessful efforts to reconnect. The default is 2 seconds.

The RecoveryIntervalFactor is used to modify the RecoveryStartInterval after the first retry is attempted, by adding the RecoveryIntervalFactor to the initial delay period. The RecoveryMaximumInterval sets the maximum delay period.

If the RecoveryIntervalFactor is 0, the RecoveryStartInterval will be used as the delay period for all retryable attempts, as the RecoveryIntervalFactor will not change the delay period.

For example: if the RecoveryStartInterval is 2 seconds, the RecoveryMaximumInterval is 16 and the RecoveryIntervalFactor is 2, the delay time between each retry attempt will be calculated as 2, 4, 6, 8, 10 12, 14, 16, 16, 16, etc.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060