Example: UEN - 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

If FILEDEF is defined as follows in an environment variable or in a default configuration file:

FILEDEF=(archive,ARCHIVE_%UEN%.DAT)

then in the following Teradata ARC script, ARCHIVE is the internal name, and ARCHIVE_%UEN%.DAT is the external name:

ARCHIVE DATA TABLES (DB), RELEASE LOCK, FILE=ARCHIVE

The final external name of this ARC script is ARCHIVE_1234.DAT, assuming that the UEN is 1234. The output of this archive displays the UEN.

Therefore, if a restore is run with UEN=1234and the above FILEDEF is used, the external name is ARCHIVE_1234.DAT in the following Teradata ARC script:

RESTORE DATA TABLES (DB), RELEASE LOCK, FILE=ARCHIVE