Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 29 Jun 2005 @ 13:41:58 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: FASTLOAD Q: Check points
From:   Reddy, Sridhar

HI Anantha,

  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?  

# You have resubmit the job. But, Make sure you do not drop those ErrorTables (err1,err2). (Its general tendency to write Drop table stmts to drop all existing error tables at the beginning of the script)

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

# FL automatically read Restart Log to Determine where to start (it stats after last Check Point)

  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?  

# Database Restart, Client System Failure, Out Of Space etc. Yes Out Of Space is one of them.



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