Read-Only on Write Failure Feature - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

From an Active state, a table may be placed in Read-only if a session encounters an error and the "Read-only on write failure" feature is turned on.

With the Read-Only on Write Failure parameter enabled, when a "INSERT to targetTable SELECT FROM sourceTable" fails on one system, the targetTable is Interrupted, a sourceTable becomes Read-Only. As a result, no further writes to sourceTable are allowed on system 1 until the INSERT-SELECT successfully completes recovery. If a write occurs on sourceTable, sourceTable is interrupted on system 1 (will need a recovery).

The feature is used in ETL environments where data is loaded to a stage table, then moved to a base table, and finally moved to a target table. This feature is not needed for a reporting environment. For mixed environment, it is recommended to keep the feature turned on.