Example: Redrive Settings and Session Behavior - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
upb1600054424724.ditamap
dita:ditavalPath
upb1600054424724.ditaval
dita:id
B035-1093
lifecycle
previous
Product Category
Teradata Vantageā„¢
When the session logs on and you have these settings... Then the session...
RedriveProtection DBS Control field is 0 will not participate in Redrive.
  • RedriveProtection DBS Control field is 1
  • Redrive field in Session Options parcel is 'Y'
  • TDWM.Redrive contains a row matching your user name, account, account string, or profile with RedriveMethod = 1 (Do not use Redrive)
will not participate in Redrive because the row in TDWM.Redrive specifies not to use Redrive.
  • RedriveProtection DBS Control field is 1
  • Redrive field in Session Options parcel is 'N'
  • TDWM.Redrive contains a row matching your user name, account, account string, or profile with RedriveMethod = 2 (Use Redrive)
will not participate in Redrive because the Redrive field in the Session Options parcel is 'N'.
  • RedriveProtection DBS Control field is 1
  • Redrive field in Session Options parcel is 'Y'
  • TDWM.Redrive does not contain any matching row or it contains a row matching your user name, account, account string, or profile with RedriveMethod = 2 (Use Redrive)
will participate in Redrive.