Example: Starting ARCHMAIN - 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

In this example, database db2 and table db3.a are not children of database db.

ARCHIVE DATA TABLES (db) ALL,(db2),(db3.a),
RELEASE LOCK,
FILE=ARCHIVE;

If the SELECT query returns 5 for db, the total number of objects in the ARCHIVE DATA TABLES statement is 7.