Archives of the TeradataForum
Message Posted: Thu, 04 Aug 2005 @ 13:33:01 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|