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.