Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 15 Mar 2005 @ 14:14:48 GMT

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

Subj:   Re: TPump Update
From:   Victor Sokovin

  You are using a pack factor of 50, which means that an MSR will include 50 update statements.  

  Remember that row level locking is not, it is row hash locking and therefore it is possible 2 updates may require the same lock even with different PI values.  

I am trying hard to understand the last sentence but am not quite there yet. However, it seems to correlate with another recent thread on the maximum number of locks. If the number of row hash locks exceeds some limit (on R3 it might be rather low), TD may opt for escalating the locks to table level. I assume TPUMP is treated in the same way as other processes as far as locking is concerned, and TPUMP does not get any extra quota on the number of such locks. I wonder whether Bill has seen any table level locks while monitoring the process. Just a speculation.



  <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: 15 Jun 2023