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 Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023