STARTAMP
Purpose
The STARTAMP parameter allows specification of a starting AMP for every all-AMP ARCHIVE job.
Syntax
where
Syntax Element |
Definition |
ampid |
Starts AMP for a single all-AMP ARCHIVE job |
Usage Notes
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.
Example
STARTAMP=1
or
AMP=1