Example: Cluster Archive - 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

This example assumes the system has four clusters, each consisting of two AMPs. Each archive is of two clusters. The procedure is divided into three jobs. Run Job 1 first, then run Job 2 and Job 3 in parallel. Finally, run Job 4. This example makes a dictionary archive and two cluster archives.

Job 1
   LOGON USER,USER;
   ARCHIVE DICTIONARY TABLES (USERDB),
      FILE = ARCHDICT;
   LOGOFF;
Job 2 (run in parallel with Job 3)
   LOGON USER, USER;
      ARCHIVE DATA TABLES (USERDB),
   CLUSTER = 0,1,
   FILE = CLUSTER1;
   LOGOFF;
Job 3 (run in parallel with Job 2)
   LOGON USER, USER;
   ARCHIVE DATA TABLES (USERDB),
   CLUSTER = 2,3,
      FILE = CLUSTER2;
   LOGOFF;
Job 4
   LOGON USER, USER;
   RELEASE LOCK (USERDB);
   LOGOFF;