Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 03 Feb 2011 @ 13:54:40 GMT

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

Subj:   Re: RELEASE MLOAD taking abnormally long
From:   Gorner, Tomas

Hi Sanjeev,

Let me correct my previous statement:

the relase mload function is executed BEFORE the multiload starts. I guess the developers wanted to be sure that there is no lock from previous failed MLOAD jobs. Anyway, I can't really question that logic right now, so let's just accept it as a fact.

So it seems that the function could not obtain an exclusive lock on the table, right? In this case, release mload function waits or it gives an error? I assume it waits, because it is not a deadlock situation. So, it would mean that there was some kind of lock (read, hash or any other) that avoids release mload function to obtain an exclusive lock. Am I right?


Tomas Gorner

  <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