DisableRecoverableNetProtocol - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

Determines whether the Recoverable Network Protocol (RNP) is enabled.

RNP prevents transactions from being aborted and database response data from being dropped due to network failures. Under RNP, if there is a network disconnect during request processing, the gateway will preserve response data buffers and will not abort transactions that were in progress at the time of the disconnect.

RNP allows clients to reconnect when the network connection is re-established, and continue processing the interrupted requests. Because transactions were not aborted, they need not be resubmitted, which can save a significant amount of time.

RNP is used only for sessions that are enabled with Redrive protection. For details on Redrive protection, see Database Administration.

This protocol is supported by CLI and JDBC.

Field Group

General

Valid Settings

Setting Description
TRUE Disables RNP
FALSE Enables RNP

Default

FALSE

Changes Take Effect

After the DBS Control Record has been written.

Usage Notes

Logons must be disabled in order to change this field. Users with appropriate privileges can disable logons from the Teradata Database system console. For more information, see Database Window (xdbw). In addition, Redrive protection must also be disabled.