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