Journaling

Database
Enthusiast

Journaling

hello friends

what is journaling?

why teradata requires journaling?

thanks and regards
Anil Reddy
1 REPLY
Enthusiast

Re: Journaling

Journling is a data protection mechanism in teradata.Journals are generated to maintain pre-images and post images of a DML transaction starting/ending at/from a checkpoint.When a DML transaction fails,the table is restored back to the last available checkpoint using the journal Images.

There are two types of Journals (1) permanent (2) transient journal.

Permanent journals are explicitly created during database and/or table creation time.This journaling can be implemented depending upon the need and available disk space.

This is abig topic in itself and you can learn more on it from teradata Manuals