Usage Notes - 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

CATALOG has two levels of granularity: OBJECT and ALL tables. If CATALOG is specified at the object level, the repositioning information is inserted into the CATALOG table for the database header record only.

Change the database in which the CATALOG table is created by adding this runtime parameter:

CATALOGDB=dbname

If CATALOGDB is not specified, Teradata ARC uses $ARC as the default CATALOG database.

Catalog information is saved in the database, therefore CATALOG enabled has a slight impact on performance. However, it is recommended that when archiving a database that contains many small or empty tables, disable CATALOG or, alternately, enable CATALOG at the object level.

Teradata ARC automatically excludes an active CATALOG database from its object list to avoid HUT lock conflicts. To archive, restore, or copy a CATALOG database, use NOCATALOG.