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. |