The STARTAMP parameter allows specification of a starting AMP for every all-AMP ARCHIVE job.
where:
Syntax Element |
Definition |
ampid |
Starts AMP for a single all-AMP ARCHIVE job |
Using STARTAMP during multiple all-AMP ARCHIVE jobs can increase archive performance. Specifying a different AMP for each job minimizes potential file contention.
If STARTAMP is not used, Teradata ARC randomly selects a starting AMP for each archived table.
STARTAMP=1
or
AMP=1