Archives of the TeradataForum
Message Posted: Thu, 13 Mar 2003 @ 20:41:31 GMT
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
|