Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 09 Mar 2005 @ 21:48:30 GMT


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


Subj:   Re: Lock Statement causing Deadlocking
 
From:   Fred Pluebell

Check the Event Log to make certain it's not really some other error (3111 or 3679) that gets reported back to the application as a 2631.

If you need to lock multiple tables for your transaction, you should name them all in the same LOCK statement or modifier, and that should be the first thing after the BT;



     
  <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: 28 Jun 2020