17.10 - DisableRecoverableNetProtocol - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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 system console. For more information, see Database Window (xdbw). In addition, Redrive protection must also be disabled.