Archives of the TeradataForum
Message Posted: Wed, 21 Apr 2004 @ 10:18:39 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|