16.10 - RedriveProtection - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

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 Teradata 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 Database 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 Topics

For more information on… See…
DISABLE LOGONS command in DBW DISABLE LOGONS/ DISABLE ALL LOGONS
Query bands SQL Data Definition Language
TDWM.redrive table Database Administration