Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 20 Feb 2015 @ 20:50:42 GMT


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


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

Raghu,

Have you checked if the dbc.dbqlxmllocktbl is being populated or not?

     select count(*) from dbc.dbqlxmllocktbl;

     select count(*) from dbc.dbqlxmllocktbl
        where collecttimestamp > current_timestamp - interval  '2'day;

I believe it is showing no data as the table dbc.dbqlxmllocktbl is empty.

Please enable dbql query logging with lock option and see if this populates the table and thus reflects in GUI.


Thanks,

Sandeep.

GANGA SANDEEP KUMAR



     
  <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