Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 16 Jun 2003 @ 14:59:50 GMT


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


Subj:   Locking and Dead Lock Issue
 
From:   PradeeP Patil

Hi all,

I am working on Java on line Application which use teradata as back end. We use stored procedures to do insertion and updating in database. For performance reason we store data in global temporary table and then do bulk insert or update at the end.

We are facing two problems locking and dead lock. Since we do bulk update there is noticeable lock period on table. This add's the waiting time for another user thus degrades the performance of second user.

In our application we have two opposite logic flooding from higher-level tables to the lower level tables. Second is roll up from lower level tables to higher-level tables. This scenario causes dead lock issue many times. We play with @ 2000 rows from single table. Can any one please guide me to overcome these issues.


Thanks,

Pradeep



     
  <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