Archiving DBC with Multi-Stream - 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

When using the multi-stream feature, database DBC can only be archived as a single-stream job. Only the single-stream option is allowed when specifying the characteristics of the job. An attempt to specify more than a single stream for an archive causes Teradata ARC to display the following error message and then terminate the job:

ARC0001:SHDUMP.DMPHASE1: DBC archive with Multi-Stream is not allowed

Due to this restriction, if a multi-stream archive includes database DBC, the archive should be split into two separate jobs. This maintains the performance improvements when using multiple parallel streams.

  1. Archive database DBC as a single-stream job:
    LOGON DBC,DBC;
    ARCHIVE DATA TABLES (DBC),
      RELEASE LOCK,
      FILE=ARCHIVE;
    LOGOFF;
  2. Archive the user data as a multi-stream job:
    LOGON DBC,DBC;
    ARCHIVE DATA TABLES (DBC) ALL,
      EXCLUDE (DBC),
      RELEASE LOCK,
      FILE=ARCHIVE;
    LOGOFF;

    If multi-stream is not required (for example, when performance is not an issue), then the entire archive job can be run as one single-stream archive job:

    LOGON DBC,DBC;
    ARCHIVE DATA TABLES (DBC) ALL,
      RELEASE LOCK,
      FILE=ARCHIVE;
    LOGOFF;
    Multi-stream archives which include database DBC and were created in Teradata ARC versions prior to 14.00 should be rerun as single-stream archives.