Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 23 Jan 2005 @ 01:29:05 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Releasing MLoad lock during the Acquistion Phase
From:   Michael Larkins

Hi Vishal:

I am glad you got what you needed. I apologize because I misread your question. During the acquisition phase the target table(s) have not been touched with any of your DML and data. I was thinking your question was in regard to the application phase when the data from the work table is being incorporated into your target table.

As you found, you can do the RELEASE MLOAD, drop your work tables, log table and error tables which allows you to rerun the job any time.

Again, sorry for my wrong impression of your situation.


Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023