DBQL field definitions

Database
Enthusiast

DBQL field definitions

Is there a document that defines the columns in the database query log tables (DBQLogTbl, DBQLSQL,... etc)? For example, I have seen various documents on Teradata performance that reference the field HotAmp1IO, but I have not see any document that actually defines what that field represents. I checked the "Performance Management" documentation from Teradata and didn't see the answer there either. Any ideas?

Thanks!
John
1 REPLY
Senior Apprentice

Re: DBQL field definitions

Hi John,
check the Data Dictionary manual:

HotAmp1IO: Returns the I/O count of the highest I/O utilized AMP in the step.

Dieter