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.