Archiving DBC with Multi-Stream
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;
Note: 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.