Archives of the TeradataForum

Message Posted: Wed, 21 Apr 2004 @ 10:18:39 GMT


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

Subj:		SHOWLOCKS and Locked DB Info

From:		Pascual, Don

Good day.

I use the 'start showlocks' in DBW to check the information on the currently locked DBs in the system. The command can only give me the following information on the currently locked DBs.

-- Data Base Name

-- Table Name (if applicable)

-- User Name of user who placed lock

-- Lock Mode

-- AMP Number

Besides this information, I would like to know the time info such as the time the DB or table has been locked and some other info that is available.

Does anyone know how to get the time info particularly the time the DB or table has been locked ? If there are any other information about the lock that can be deduced, please tell me that command also.

Thank you very much and more power to everyone.

Donn