Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 20 Feb 2015 @ 20:30:28 GMT


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


Subj:   Re: Lock viewer in viewpoint 15
 
From:   Anderson, Catherine

In Teradata 14.10, lock logging moved to DBQL. The console utility Lock Logger utility is still supported but deprecated. Here is an excerpt from the Release Summary explaining the new feature:

DBQL now logs lock delays in XML with a new LOCK option for the BEGIN QUERY LOGGING and REPLACE QUERY LOGGING statements. For example:

     BEGIN QUERY LOGGING WITH LOCK = [XXX] on YYY;

You can choose a length of time in centiseconds at which a lock contention is significant enough to be logged (XXX) or limit lock logging to a specific user, account ID, or application (YYY). You can access the DBQL lock log through the Viewpoint Lock Viewer portlet or query the system table DBC.DBQLXMLLOCKTBL or the view DBC.QrylockLogXMLV.



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019