DBQL table definitions

UDA
Enthusiast

DBQL table 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
Enthusiast

Re: DBQL table definitions

Hi,
Those are the called system views (dbc.dbqlsql,dbc.tables,dbc.columns etc...) which we can find in Data dictionary PDF.You can refer that PDF.