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

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