Completing a Checkpoint With Offline AMPs - 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

Issuing a checkpoint statement while AMPs are offline is permissible. If AMPs are offline when a checkpoint is issued, Teradata ARC automatically generates a system log entry that takes the checkpoint on the offline AMPs as soon as they return to online status. The system startup process generates the checkpoint and requires no further action.

In addition to generating the checkpoint entry in the journal, system recovery updates the journal table with change images that were generated while the AMP was offline. These change images are for fallback tables or dual image journals that should be on the AMP that was offline when the system took the checkpoint.