All Forums Database
nyemul 14 posts Joined 09/12
20 Oct 2012
Explanation of fields in DBQLOGTBL and how to use info present in it

Hello,
Which document will contain explanation of fields in DBQLOGTBL?
Some of the fields of interest are as follows.
EstMaxRowCount, NumSteps, StatementType, WDID, LSN Integer, SLGMet etc.
 
Is there any document or guide that contains how to obtain required information from DBQLOGTBL. One of the objective is to understand where a query is taking more time and analyze it further. DBQL log tables might provide clues.
Thanks,
Niteen

Tags:
D3V1L 10 posts Joined 01/12
20 Oct 2012

Book: Teradata User Documentation => Database administration
Chapter 14: Tracking Processing Behavior with DBQL
Things to Consider When Logging DBQL Data

Cheers!
d3V1L

Experience is what we get, when we don't get what we want!

D3V1L 10 posts Joined 01/12
20 Oct 2012

Check this out
http://developer.teradata.com/blog/carrie/2012/07/intrepreting-dbql-delaytime-in-teradata-13-10

Cheers!
d3V1L

Experience is what we get, when we don't get what we want!

You must sign in to leave a comment.