Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 25 Feb 2003 @ 21:33:07 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Table locks during Multiload Vs SQL Update
From:   Rohit Revo

The behaviour is completely as expected of Teradata.

The advantage of using Deleting a table with MLOAD far outweigh the advantages of SQL Delete. Remeber that in MLOAD Delete you have the maximum possible access to the Table rather than SQL Delete and it is restartable too (from where it left last time after Teradata recovery), with no Transient Journal. It is only in the Application phase that you will not have access to the table and you must have accessed this table in the Application Phase. Check the MLOAD logs to see where MLOAD process is at that moment.

If you still want to access info during this MLOAD phase use an ACCESS Lock, which is compatible.

You get hell lot of info from MLOAD logs again not possible in SQL processes.

In the second example of yours, if there is WRITE LOCK a READ LOCK will also work and that is why you get the output. A Write Lock and then a Read Lock are compatible. Not the reverse.


  <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