Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 20 Feb 2015 @ 17:53:31 GMT

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

Subj:   Re: Lock viewer in viewpoint 15
From:   Ganga, Sandeep Kumar

Hi Raghu Maram,

The Lock Info collector uses the data written to the DBC.DBQLXMLLockTbl table to capture lock information. For which this need DBQL query logging must be enabled with the WITH LOCK option.

Please make sure the locking logger for userx is turned on and set the lock threshold to 5 cent seconds.

Thus in which the table dbc.dbqlxmllocktbl starts to populate and gets reflected the same in Lock viewer.




  <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: 15 Jun 2023