No rows in DBC.DBQLStepTbl.

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Enthusiast

No rows in DBC.DBQLStepTbl.

Dear Friends,

 

i dindt find any rows stored in the table DBC.DBQLStepTbl. might be it is required some enable at database level.

 

Could you please suggest.

 

Thanks in advance!

3 REPLIES
Junior Contributor

Re: No rows in DBC.DBQLStepTbl.

Like all DBQL tables it must be enabled using BEGIN QUERY LOGGING: WITH STEPINFO

Enthusiast

Re: No rows in DBC.DBQLStepTbl.

Thanks dnoeth. kindly let me know, is it required for every dbc tables we should enable one by one.

 

i can there number of tables are empty. few are below

 

SyntaxEditor Code Snippet

SEL TOP 10  * FROM DBC.QUERYSTATSV;
SEL TOP 10  * FROM DBC.QUERYSTATUSECOUNTV;
SEL TOP 10  * FROM DBC.UPDATEUSECOUNTV  ;
SEL TOP 10  * FROM DBC.STATUSECOUNTV   
SEL TOP 10  * FROM DBC.VIEWSTATSV;
SEL TOP 10  * FROM DBC.QRYLOGSTEPSV;
SEL TOP 10  * FROM DBC.QRYLOGSQLV;
Junior Contributor

Re: No rows in DBC.DBQLStepTbl.

Please read the chapter Tracking Query Behavior with Database Query Logging: Operational DBAs in the Database Administration manual for your TD release.