Archives of the TeradataForum
Message Posted: Wed, 05 Aug 2015 @ 08:24:22 GMT
Good point, I didn't make this area clear enough.
With the INSERT/SELECT you will also get a table-level lock.
The point I wanted to make about loading directly into a target table - using something like Multiload or TPT Update - is that there is a difference in locking. Using these utilities the locks used are not transaction locks so in case of failure they are not released. You essentially have to complete the job before they get released. (or abandon the job and fix the data manually). With an INSERT/SELECT the lock gets released when the transaction has completed, either successfully or otherwise. The dbms sorts out the data for you.
Using Tpump/TPT Stream will place rowhash locks.
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|