16.20 - Archiving Source Data Using the ARCHIVE Command - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Node Software Migration Guide

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
Configuration
Installation
featnum
B035-5942-162K
The following script examples show archiving using the ARCHIVE command.
  1. Archive database DBC by submitting a job with the following ARC commands:
    LOGON tdp/dbc,dbc_password;
        ARCHIVE DATA TABLES (DBC),
        RELEASE LOCK,
        FILE=ARCHIVE;
        LOGOFF;
  2. Archive the journal tables by submitting a job with the following ARC commands:
    LOGON tdp/dbc,dbc_password;
        ARCHIVE JOURNAL TABLES (DBC)ALL,EXCLUDE(DBC),
        NONEMPTYDATABASES,
        RELEASE LOCK,
        FILE=JNLARCH;
        LOGOFF;
  3. Archive user databases:
    • If you are not certain that the destination system has adequate space for all user data, create multiple archives containing different user databases by submitting jobs using the following ARC commands:
      LOGON tdp/dbc,dbc_password;
          ARCHIVE DATA TABLES (database_1) ALL, (database_2) ALL,...,(database_n) ALL,
          RELEASE LOCK,
          FILE=user_archive_file_n;
          LOGOFF;
      Teradata recommends this method, because it guards against needing to restore all user data more than once, which would happen if the destination system has inadequate space. Do not archive databases DBC, TD_SYSFNLIB, CRASHDUMPS, SYSLIB, SYSSPATIAL, and SYSBAR when you archive user data.
    • If you are certain that the destination system has adequate space for all user data, you can create a single archive containing all user databases by submitting a job with the following ARC commands:
      LOGON tdp/dbc,dbc_password;
          ARCHIVE DATA TABLES (DBC) ALL, EXCLUDE(DBC), (TD_SYSFNLIB), 
         (CRASHDUMPS), (SYSLIB), (SYSSPATIAL), (SYSBAR)
          RELEASE LOCK,
          FILE=USRARCH;
          LOGOFF;
  4. Archive database SYSLIB:
    LOGON tdp/dbc,dbc_password;
        ARCHIVE DATA TABLES (SYSLIB) ALL, 
        RELEASE LOCK,
        FILE=SYSLIBONLY;
        LOGOFF;