Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 21 Feb 2001 @ 10:12:27 GMT

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

Subj:   Re: Multiset load restarts
From:   David Wellman


Where is (or where do think will be) the problem?

Multiload will handle restarts of a failed load. It will re-read through the input file until it reaches the last known checkpoint and start loading the data from that point. During the sort phase it will get rid of any input records that it has loaded more than once, so you won't end up with the same data multiple times.

70-80 million records could be quite a few tapes. With a vanilla multiload then you can't stop the restart from reading through from the beginning (as far as I know) - if this is your problem you'd have to code something in an inmod/access module to quickly get to the last checkpoint.

Does that help?



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023