Example 2: Offline Amp - 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

This example archives all nonfallback data from an AMP that was offline during a previous Teradata Database archive operation.

LOGON DBC,DBC;
ARCHIVE NO FALLBACK TABLES (DBC) ALL,
   AMP=3,
   EXCLUDE (DBC),
   RELEASE LOCK,
   FILE=ARCHIVE;
LOGOFF;