17.10 - RedriveProtection - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Determines system-level support for the Redrive feature. After a system restart, the Redrive feature preserves responses for completed requests and resubmits uncompleted requests.

Field Group

General

Valid Settings

Setting Description
0 Redrive is disabled. Automatic request resubmission cannot occur.
1 Memory-based automatic request resubmission is enabled.

SQL request text is maintained in memory on the requesting PE node. The request is automatically resubmitted after a database restart. Completed responses are stored in persistent spool tables.

Default

0 on systems that are upgraded from Teradata Database releases prior to 14.10.

1 on systems that are initialized on Teradata Database 14.10 or later.

Changes Take Effect

After the next Teradata system restart.

Usage Notes

To disable Redrive, you must disable logons from the Supervisor window of Database Window (DBW) or similar console subsystem interface, such as cnsterm. Ensure that no sessions are logged on before setting RedriveProtection to 0.

The Redrive feature can be enabled and disabled at the session level using the REDRIVE query band and by means of the TDWM.redrive table, which can determine if redrive is used at the user, account, or profile level.

Related Information

For more information on… See…
DISABLE LOGONS command in DBW DISABLE LOGONS/ DISABLE ALL LOGONS.
Query bands Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.
TDWM.redrive table Teradata Vantage™ - Database Administration, B035-1093.