Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 29 Jan 2008 @ 11:09:24 GMT


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


Subj:   Re: Locking Row for Access Stmt
 
From:   Ramchandran, Janardhan

Hi,

Access lock is a dirty locked placed on both the tables and rows which has been under transaction.So placing the access lock on the table as well as on the rowhash levels won't affect any of your performance ,while the access lock has been placed on your table or row is still available for any other locks,so workloads will be processed as its way.

Note:- By placing the access lock and retrieving the data will give you the inconsistent data.


Tera-Jana



     
  <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: 27 Dec 2016