Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 16 Feb 2005 @ 15:12:05 GMT


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


Subj:   DBC Access for Table Delete?
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, February 16, 2005 10:01 -->

Hi,

We have noticed some deadlocks on our system when doing deletes from certain tables.

The tables in questions are all unique to the particular jobs which run them (so nothing else, apart from the job running the delete script) would ever access these tables.

Why then, are we getting a deadlock, and with what??

Any any entries made anywhere in DBC when you delete all rows from a table? (The explain doesn't show any).


Thanks.



     
  <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