Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: NoPI tables as Staging tables
From:   Dave Wellman


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)

  <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