Example: Archiving when all AMPS are Online - 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

The following example archives all databases when all AMPs are online:

LOGON DBC,DBC;
ARCHIVE DATA TABLES (DBC) ALL,
RELEASE LOCK,
FILE=ARCHIVE;
LOGOFF;

When the archive operation is complete, check the output log to verify that all AMPs remained online during the archive.

If an AMP goes offline during an archive, the output log reports the processor number that is offline. If one or more AMPs go offline, see Offline AMPs.