Example: The CATALOG Table - 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

For UEN 1234, the following table is automatically created at the beginning of an archive operation:

$ARC.CATALOG_1234

If an error occurs when creating the CATALOG table, Teradata ARC terminates with a fatal error. Correct the error and resubmit the archive job.

During an archive operation, a CATALOG table row is inserted at the following instances:

  • For each object, a database level CATALOG row is inserted at the end of the dictionary phase.
  • For each table in the database, if the object level has not been specified, a table level CATALOG row is inserted at the end of the data phase.

The CATALOG tables can be used for detailed archive history in conjunction with the database DBC.RCEvent table. For information on the database DBC.RCEvent table, see the Data Dictionary (B035-1092).