Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 04 Aug 2005 @ 13:33:01 GMT


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


Subj:   How to Identify LOCKS using Data Dictionary and Queries.
 
From:   MOHAN WAGH

Dear All,

I am using TeraData version V2R5.

Scenario
--------

I am using FLoad or MLoad or Updating some values from a Table. During all these operations various types of LOCKs are acquired on the affected object. If my MLoad or FLoad fails, then in many cases the locks don't get released.

My Question is...
-----------------

How to identify, in my TeraData Database HOW MANY LOCKS and HOW MANY OBJECTS have been locked (NOT using any TOOL, but ONLY Using Data Dictionary available in DBC and SQL Select statements)?

Need express help in this regard,

Thanking you,


regards,

Mohan Wagh.



     
  <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