Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

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

Dear All,

I am using TeraData version V2R5.


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,


Mohan Wagh.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020