Restoring AMPs Locally - 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

Whenever possible, Teradata ARC attempts to restore/copy AMP data using sessions that are local to each of the AMPs. This minimizes the amount of data that must be transferred between nodes for the restore to complete.

The Local AMP feature is supported during restores/copies on all-AMP jobs, cluster jobs, and multi-stream jobs.

In order for the Local AMP feature to work, Teradata ARC must be able to log on to a MONITOR session to determine AMP location information. To grant this privilege, enter the following SQL statement:

GRANT MONITOR TO  <arcuser>;
where <arcuser> is the user account which ARC is using to perform the backup.
The Local AMP feature is not supported on Mainframe systems.

See also Archiving AMPs Locally.