15.00 - RedriveProtection - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

RedriveProtection

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” on page 166

Query bands

SQL Data Definition Language

TDWM.redrive table

Database Administration