Enabling Redrive Protection - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™
To enable Redrive protection... Do...
at the system level Set the RedriveProtection DBS Control field to 1.
for all sessions by default
  • Ensure that the RedriveProtection DBS Control field is set to 1.
  • Set the RedriveDefaultParticipation DBS Control field to 1.
at the session level Set the Redrive field in the Session Options parcel to 'Y'.
at the user, account, or profile level Insert or modify a row in the TDWM.Redrive table and set the value of the RedriveMethod column to 2 for the user, account, or profile. For details, see Setting Redrive Protection for Users, Accounts, and Profiles.
If any of the following is true, the session will not participate in Redrive:
  • The RedriveProtection DBS Control field is set to 0
  • The Redrive field in the Session Options parcel is set to 'N'
  • There is a row in the TDWM.Redrive table indicating that Redrive is disabled for this session

In addition, Recoverable Network Protocol must be enabled in order for you to use Redrive. For details about Recoverable Network Protocol, see the DisableRecoverableNetProtocol DBS Control field in Teradata Vantage™ - Database Utilities, B035-1102.

The Redrive capability is assigned to a session at logon time. Once a session is enabled with Redrive, you can subsequently use the Redrive query band to toggle Redrive protection off and on during the life of the session using this syntax:

   SET QUERY_BAND = 'redrive=on;' FOR SESSION;
   SET QUERY_BAND = 'redrive=off;' FOR SESSION;

For details on using the Redrive query band, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.