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

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).