Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 01 Jul 2013 @ 12:52:20 GMT

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

Subj:   Re: Rowhash Blocking
From:   sobhan.pratim


Row hash locks happens when you use TPUMP or some ETL utility to update or insert a record etc.

For example an Insert operation will produce row hash write lock to check Duplicate row insert as well as some READ operations on the same record.

So my question is if you expect something else than this? I think it's usual behavior or check duplication before insert etc.



  <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