Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 05 Jul 2011 @ 15:17:40 GMT

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

Subj:   Re: Override and Inapply while releasing locks
From:   Ramachandran, Janardhan

Hi Sridharan,

There is no releation between the block level data transfer and the locks.Locks are applied for the table integrity purpose.

We have the option of release lock for the Mload failures, as it can locks the populated target table.The locks are not released on the tables during the failure as the Mload can be restarted.

Fast export just applies the read lock and there is no need of release lock option in the failures.

Fast load just apply the locks on the empty table,so there by we don't need the option of release lock.

Thanks & regards

Janardhan R

  <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