Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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.


  <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