Archives of the TeradataForum

Message Posted: Thu, 05 Dec 2002 @ 13:34:39 GMT

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

If you were to have a storage drive fail while your MLOAD was in progress and the error/log tables were non-Fallback, the MLOAD could not complete successfully and your target table would be in an incomplete state until the failed drive was rebuilt and the MLOAD completed. Because incomplete MLOADs leave you exposed to target table corruption and prevent other processes from writing to that table, it is wise to do all you can to avoid this state.

With Fallback on both the log/error tables and the target table, the MLOAD keeps running with no issues when a drive fails.

Adam

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