Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 15:05:29 GMT


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


Subj:   How to reset a fasltoad job
 
From:   Villeneuve Philippe

Hello,

During the fastload operation we have reached the default error limit (1 000 000). The fastload job (sent by unix script shell) was paused. We now have the two error tables but we can't acces them because they are locked

Message : << Operation not allowed : table is being loaded>>

fastload log :
**** 12:31:09 ER RLIMIT exceeded
 -------------------------------------------------------------------
 -
 - Logoff/Disconnect
 -
 -------------------------------------------------------------------

**** 12:31:09 Logging off all sessions
**** 12:31:11 Total processor time used = '20.1 Seconds'
. Start : Thu Mar 13 12:27:59 2003
. End : Thu Mar 13 12:31:11 2003
. Highest return code encountered = '12'.
**** 12:31:11 FastLoad Paused

How can i unlock the rreor tables and end the fastload job? Is it possible to avoid fastload to pause rather than to end (I intercept the error code to see if it is ok).


Thank you,

Bests regards

Philippe VILLENEUVE
CTRCEAPC



     
  <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: 27 Dec 2016