When CHECKPOINT writes rows to a journal, the transient journal also keeps a record of these rows. Consequently, if the Teradata Database fails, the results of the checkpoint operation are rolled back by the transient journal.
- If Teradata ARC statement specified checkpoints on multiple journal tables, Teradata ARC rolls back only the checkpoint being taken at the time of the hardware failure.
- If CHECKPOINT terminates abnormally, all locks Teradata ARC placed are removed.
When Teradata ARC restarts, the CHECKPOINT statement completes.