Archives of the TeradataForum
Message Posted: Sat, 22 Jan 2005 @ 16:07:28 GMT
| Subj: | | Re: Releasing MLoad lock during the Acquistion Phase |
| |
| From: | | Michael Larkins |
Vishual:
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
| 
