Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 19 Nov 2010 @ 13:01:19 GMT


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


Subj:   Re: Automatic Database Lock Levels Question
 
From:   DWellman

Hi,

You're correct, the table doesn't make a lot of sense for these lines.

When issuing a CREATE/MODIFY/DROP Database command then the Database object is locked with an exclusive lock.

The "locking level by acess type" columns in the table are only really relevant for the DML commands listed, i.e. they're showing the types of locks placed when (for instance) you run a SELECT statement that accesses the table via a UPI/NUPI/USI index. In this case the lock placed is a rowhash lock.

For DDL commands against the table or database then such access doesn't happen, therefore that entry in the table is "not applicable".


Hope that helps.

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )



     
  <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