Journaling - Analytics Database - Teradata Vantage

Database Introduction

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-09-27
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
Product Category
Teradata Vantageā„¢

A journal is a table of records of some kind of activity. The system does some journaling automatically. You can specify whether to perform other journaling.

The following table explains the capabilities of the different database journals.

Journal Type Description
Down AMP recovery
  • Always occurs.
  • Active only during an AMP failure.
  • Journals only fallback tables.
  • Used to recover the AMP after the AMP is repaired, discarded afterward.
Transient
  • Always occurs.
  • Logs BEFORE images for transactions.
  • Used by system to roll back failed transactions aborted by user or system.
  • Captures the following:
    • 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.
Permanent
  • Occurs as you specify.
  • Is available for tables or databases.
  • Can contain BEFORE images (which enable rollback), or AFTER images (which enable 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.