Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Thu, 13 Mar 2003 @ 20:41:31 GMT





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




Subj:   Re: How to reset a fasltoad job
 
From:   Raghav Vaidya



Run another Fastload job with just the End Load parameter in it.

That will terminate the Fastload & release all locks.

One way to avoid this situation is to increase your errorlimit. But that would unneccessary fill up the database the error tables are built in. Unless you always expect a very high volume of errors, it is a very good idea to keep the errorlimit to at an acceptable level. If you get a very high volume of records in the error tables, maybe the data is not pure.


Hope this helps.

Raghav





     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008