Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 05 Jul 2011 @ 14:34:02 GMT

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

Subj:   Re: Override and Inapply while releasing locks
From:   Gorner, Tomas


AFAIK, "Release Lock...Override" is used for Host Utility Locks, when a table is beign archived, for example. Someone correct me if I'm wrong.

Release mload is a completely different thing. Especially "in apply" should be used with extra caution. You can end up with a corrupted table very easily. Basically, "release mload in apply" releases lock on a table where multiload is in application phase already. i.e. applying changes to your target table. If you release lock in this phase, it is pretty difficult (if not impossible) to restart your multiload job and the data in the table might be inconsistent.

For more information, please refere to Multiload documentation.



  <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