Archives of the TeradataForum
Message Posted: Wed, 27 Nov 2002 @ 10:23:57 GMT
<-- Anonymously Posted: Tuesday, November 26, 2002 23:53 -->
We have a situation where Multiload is being used to load 500MB of data in a short time window. We face two problems:
1. In some trials MLoad crashed in the middle of the "application" phase, and recovery was very problematic. Has anyone faced similar problems? What are the options available to us?
2. As MLoad does table-level locking, the table is not accessible for a long period. Are there any ways around this problem?
While TPump is being used to load currently, the time taken is much larger than the load window available, and multiload seems to be the only option.
The load platform is NT.
Would really appreciate any pointers to proceed further.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|