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