DBQL field definitions

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

DBQL field definitions

Rate Topic

Display Mode

Topic Options

Author

Message

jzlamal

Posted 11/3/2009 3:36:00 PM

Forum Newbie

Group: Forum Members
Last Login: 11/18/2009 4:07:50 PM
Posts: 4, Visits: 8

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

Post #17220

dnoeth

Posted 11/5/2009 4:49:48 PM

Supreme Being

Group: Forum Members
Last Login: 11/5/2009 4:40:02 PM
Posts: 717, Visits: 466

Hi John,
check the Data Dictionary manual:

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

Dieter

Post #17267

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 3:53am