Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 10 Dec 2015 @ 09:20:25 GMT

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

Subj:   Re: Serialize and Pack factor for TPUMP jobs -
From:   Gupta, Vipin

Thanks for the responses.

I believe that is what happening here. Within a "pack" not only common value rows but different rows with different values(of key) are being sent. This causes transaction to demand locks on more than 1 AMP and it conflicts with the all AMP delete query leading to deadlock.

In the viewpoint as well, I can see that AMPs participating for TPUMP sessions are 30 and more. That also proves the point and behavior.

Any suggestion to improve and reduce deadlock frequency in such scenarios where TPUMP is 24X7 job and all AMP bteq delete also comes in between?



  <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: 24 Jul 2020