No rows in DBC.DBQLStepTbl.

[Sridharan]

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!

[dnoeth]

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

[Sridharan]

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;

[dnoeth]

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