Usage Notes - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities

Specifying CHECKPOINT with the SAVE keyword prepares a journal table for archiving. Teradata ARC writes a checkpoint row to the active journal table. This subtable is then appended to any existing saved table of the named journal. Archive this saved portion by using ARCHIVE JOURNAL TABLES.

The Teradata Database returns an event number that Teradata ARC assigns to the checkpoint entry.

Checkpoint functionality with regards to permanent journals is supported on both Mainframe systems (z/OS) and network-attached systems.