Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 03 Feb 2011 @ 12:12:32 GMT

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

Subj:   Re: RELEASE MLOAD taking abnormally long
From:   Sidana Sanjeev

Hi Tomas,

If the Mload has already completed successfully then what is the need to run "release mload". How did you verify that?

Following are the details about release mload command:

Release Mload puts an exclusive lock on the target table.

The RELEASE MLOAD command:

* Cannot run until all access locked queries are either completed or aborted

* Does not complete until it obtains an exclusive lock on the target tables

  <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