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.
- Archive database DBC as a single-stream job:
LOGON DBC,DBC; ARCHIVE DATA TABLES (DBC), RELEASE LOCK, FILE=ARCHIVE; LOGOFF;
- 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.