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

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;