Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 29 Jun 2005 @ 13:26:01 GMT

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

Subj:   Re: FASTLOAD Q: Check points
From:   Victor Sokovin

  1. If we checkpoint loading at intervals, and the FL gets interrupted, how do we restart it? should we just relaunch the FL job script again? Or should we truncate the data file till the last checked point?  

Just restart and let TD do the job.

  2. How do we know the last record that was checkpointed?  

Good question. I don't know. Probably because I was never particularly interested in this. See above.

  3. what are the scenarios under which a FL job script might get interrupted? will the database running out of space be one among them?  

That would be one of the typical reasons. File layout, problems with data types, field lengths etc would be other reasons.

If the input file requires editing, I for one forget about any committed checkpoints in this case and repeat the FL job from scratch on the new version of the file.



  <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