Journaling - Advanced SQL Engine

Journaling - Advanced SQL Engine - Teradata Database

Database Introduction

Product

Advanced SQL Engine

Teradata Database

Release Number

17.10

Published

July 2021

Language

English (United States)

Last Update

2021-07-27

dita:mapPath

jiv1600056352873.ditamap

dita:ditavalPath

jiv1600056352873.ditaval

dita:id

B035-1091

lifecycle

Product Category

Teradata Vantage™

Teradata Database supports tables that are devoted to journaling. A journal is a record of some kind of activity. Teradata Database supports several kinds of journaling. The system does some journaling on its own, while you can specify whether to perform other journaling.

The following table explains the capabilities of the different Teradata Database journals.

This type of journal…	Does the following…	And Occurs …
Down AMP recovery	Is active during an AMP failure only Journals fallback tables only Is used to recover the AMP after the AMP is repaired, then is discarded	always.
Transient	Logs BEFORE images for transactions Is used by system to roll back failed transactions aborted either by the user or by the system Captures: Begin/End Transaction indicators Before row images for UPDATE and DELETE statements Row IDs for INSERT statements Control records for CREATE, DROP, DELETE, and ALTER statements Keeps each image on the same AMP as the row it describes Discards images when the transaction or rollback completes	always.
Permanent	Is available for tables or databases Can contain before images, which permit rollback, or after images, which permit rollforward, or both before and after images Provides rollforward recovery Provides rollback recovery Provides full recovery of nonfallback tables Reduces need for frequent, full-table archives	as specified by the user.