Archives of the TeradataForum

Message Posted: Wed, 27 Nov 2002 @ 18:48:42 GMT

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

By 'recovery' are you talking about aborting the Multiload and manually sorting out your data? In which case, yes it will quite possibly be problematic. Could permanent journalling help here? (sorry, just thinking off the top of my head) I think it probably could although obviously it will slow down the Multiload job.

If by 'reovery' you're talking about completing the Multiload then that really shouldn't be a problem. In my experience, Multiload restart processing is very robust. The real trick is DO NOT CHANGE ANYTHING in the script or NT command file which controls Multiload (apart from fixing the problem) and simply let Mload handle all restart processing.

Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

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