Transient Journaling Supported by CREATE TABLE (Table Options Clause) - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The transient journal is a system-maintained dictionary table that provides a way to protect transactions from system failures and from deadlock (see Deadlock for a description of deadlock). Each transaction processed by Vantage records a before change image of rows that are touched by the transaction. Then if a transaction fails, the before change image of any modified rows can be retrieved from the transient journal and written over the modifications, returning the row to the same state it was in before the transaction occurred. Vantage removes all before change images from the transient journal after a transaction commits.