Example 1: Offline AMP - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
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 notout 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.