Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 09 Jun 2015 @ 22:41:01 GMT


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


Subj:   Re: Write Lock - Partition level
 
From:   Sravan.Bodla

Hi Sridhar,

Thanks for this post.

"Row Hash locks will upgrade to Table level write lock when there are multiple row hashes or sub queries in where condition though PI or USI column is included".

Just sharing a similar issue which I had a few weeks back:

An Informatica job (which has Inserts and updates) with PDO logic with more than 100 sessions in a single job, was failing due to "Dead Lock" Issue in Prod and was successful in Dev.

In DEV and PROD, the DDL was same, Update statement was same but PI was different.

In DEV they were updating a non PI column which was placing row hashlocks and in Prod the updates were on PI column which is a Table level lock leading to Deadlock.

You have put it in a better way to understand and explain. :-)


Thanks!

Sravan



     
  <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: 23 Jun 2019