Explanation of fields in DBQLOGTBL and how to use info present in it

Database
Enthusiast

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 (1)
2 REPLIES
Enthusiast

Re: Explanation of fields in DBQLOGTBL and how to use info present in it

Book: Teradata User Documentation => Database administration

Chapter 14: Tracking Processing Behavior with DBQL

Things to Consider When Logging DBQL Data

Enthusiast

Re: Explanation of fields in DBQLOGTBL and how to use info present in it