RedriveDefaultParticipation - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Determines whether or not the Redrive feature is used for all sessions by default. This field is effective only when the RedriveProtection field is set to enable Redrive.

Field Group

General

Valid Settings

Setting Description
0 Redrive participation is disabled by default for all sessions.

Automatic request resubmission will not occur for all sessions. You can enable Redrive for an individual session using logon parameters or query bands.

1 Redrive participation is enabled by default for all sessions.

All sessions within the system will have their uncompleted requests automatically resubmitted after a database restart. You can disable Redrive for an individual session using logon parameters or query bands.

Default

0

Changes Take Effect

After the next Teradata system restart.

Usage Notes

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…
Query bands Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.
TDWM.redrive table Teradata Vantage™ - Database Administration, B035-1093.