Archives of the TeradataForum

Message Posted: Wed, 05 Aug 2015 @ 08:24:22 GMT

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

HI,

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.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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