Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 12 Dec 2003 @ 20:18:32 GMT


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


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

  OK. So, you are happy with the staging table and your concern is only about the master table, right?  


Yes, that's right.


  From your original posting I understood that you store only one month at a time in the master table. If there are multiple months my suggestion to restructure the PI should include the month column as well.  


Yes - we only store the one month in the Master table. That being the case, I suppose we could just delete by company_cd, so I see where you are going there.


  It would be good to understand what causes the table lock. May I ask how you do your deletes exactly? You do not use MLOAD, right? Do you have SIs on the master table?  


The deletes are performed with BTEQ scripts (no MLOAD). We do not have any secondary indexes on the Master table at this time.


  That would be my bet. We should be able to do concurrent transactions,shouldn't we? The PI way should be the easiest for TD.  


I can look at that option and see if its helps at all.


Thanks a lot for taking the time to respond!



     
  <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