Archives of the TeradataForum

Message Posted: Mon, 16 May 2005 @ 14:00:05 GMT

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

Sure. To get this error message it is enough to run out of space on one AMP. Data skew is a typical reason for this. Check 1) the data distribution on the PI columns in the file your are loading; 2) data skew in all the tables in UAXA. As you have already identified the AMP causing the problem I think 2) is the first thing to check.

The remedy is either to add more space to UAXA or rebuild the skewed table(s) using new PI definitions. The latter solution is probably better long-term but you will have to make sure that the new definitions do not create other problems.

Regards,

Victor

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