Archives of the TeradataForum

Message Posted: Thu, 25 Oct 2012 @ 09:22:33 GMT

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

2720 Fast/MLoad or FastExport has already been terminated.

Explanation: If this was a FastLoad or MLoad job then the load operation on the DBS side has already been terminated, but data parcels are still being sent down from the host. Possible cause is the Host Load Utility is ignoring the error returned from DBS.

If this was a FastExport job then the FastExport session has been logged off. The SQL Select is either aborted or if it has been completed then the logoff results the answer set inaccessible. In the latter case, the host must submit an End Request to delete any spool files created on the AMPs.

Generated By: AMP Load Processing.

For Whom: Host Load Utility.

Notes: The Utility should terminate if there is any error returned while it is sending data parcels to the DBS.

Remedy: Cancel the Load job on the Host. Correct the Utility if it is ignoring errors.

Check the user space in DBS system after sending 800 million records. Is anyone monitoring DBS load? I think, DBS is over loaded. In which phase this error is published by Mload?

Can you post the complete Multiload output (remove any sensitive data :)).

Regards,

Sudhansu

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