Archives of the TeradataForum

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

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

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>>