Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 06 Jul 2012 @ 16:36:51 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: How to restart Fload and Mload
From:   Anomy Anom

<-- Anonymously Posted: Friday, July 06, 2012 10:24 -->

Beware some oft-repeated but bad advice in this thread.

You should never drop MLOAD error, work, or log tables until after RELEASE MLOAD succeeds. That way if you were in APPLY phase you still have the option to restart & continue. The sequence matters.

RELEASE MLOAD IN APPLY is a last resort and should rarely if ever be used. There is no way to determine how many inserts/updates/deletes were applied already or to back them out. Better to restart and let MLOAD complete if at all possible.

Also note that for FastLoad there is no "release" statement but you can do BEGIN LOADING / END LOADING (with no INSERT) to release the lock.

Again, don't drop error tables until after releasing the lock or you will lose this option.

Finally, note that original poster asked about "restart", specifically in application phase, not "start over". Those are different things.

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020