Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 12 Dec 2003 @ 16:12:35 GMT


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


Subj:   Concurrent Loads/Deletes for Staging Table
 
From:   Duane Angle

We have a month end process where 30 countries send us their "numbers" for the month, but can re-post the data any number of times over the course of a week. We currently load all 30 countries into the same end table. The end table has a Primary Index of Customer_Nbr and Material_Nbr. Each country sends its data in by month and country_cd - so they delete from the final table for the current month and their own country cd then re-insert the data.

The problem is that if multiple countries come in at the same time, they have to wait in line because Teradata is performing a table lock on the table.

We've tried a row hash lock, but the loads were still single streamed.

Seems odd that each country can't delete and load its own data (no overlap) on the same table concurrently, but there doesn't seem to be a way around this in Teradata.

Any ideas, or is the only way to get a concurrent load going to load each country to its own table.

Hope this makes sense.


Thanks in advance!

Duane



     
  <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: 27 Dec 2016