Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 22 Jan 2005 @ 16:07:28 GMT

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

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


If this is a production table you probably do not want to release the lock. Instead, the recommended procedure is to fix the cause of the abort and restart Mload so that it can finish successfully and release the lock itself.

The problem is that part of your inserts, updates or deletes have been completed but others have not. Your table is partially changed. If you terminate the Mload and release the lock, you cannot restart the job and your table can be lacking data integrity.

Just a thought,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

  <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