Example 1: 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 databases when one AMP is offline with Teradata Database. In this case, the offline AMP is not out of service because of a disk failure.

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

When the archive operation is complete, check the print file to verify that the offline AMP did not come back online during the archive. If the offline AMP came back online during the archive, the print file reports the following with Teradata Database, where n is the number of the AMP:

AMP n BACK ON-LINE

When the offline AMP returns to online operation, run another archive procedure to archive rows from the offline AMP, even if the AMP came back online during the archive.