Archives of the TeradataForum

Message Posted: Tue, 10 Feb 2004 @ 13:34:50 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You can do this, but you'll need to COPY the cluster files to the target Teradata server sequentially, as all-AMP copy jobs(run an all-AMP dictionary COPY first). It's necessary to run them as all-AMP as the number of AMPs/clusters on the source system will not be the same as the target system, so you need to redistribute the data across the new AMP config. Specify NO BUILD in each of the cluster COPY jobs, and perform a single BUILD DATA TABLES once you've completed all cluster restores.

Cheers,

Mark

	<Prev	Next>		<<First	<Prev	Next>	Last>>