Controlling Journal Checkpoint Operations - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

Controlling Journal Checkpoint Operations

A checkpoint places a marker at the chronological end of the active journal subtable. When the checkpoint is taken, the Teradata Database assigns an event number to it and returns that number as a response to the CHECKPOINT statement. A name can be supplied with CHECKPOINT and used to reference the checkpoint in future operations.

During a checkpoint with a save operation, the Teradata Database logically appends the active subtable of the journal to the end of the saved subtable, then it automatically initiates a new active subtable.

Archiving or deleting only the saved subtable of a journal is possible. An ARCHIVE JOURNAL TABLE statement copies the saved subtable to the client. Use a DELETE JOURNAL table statement to physically purge the saved subtable.