SQL Query - DBQL table

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.

SQL Query - DBQL table

Rate Topic

Display Mode

Topic Options

Author

Message

Nageswarareddy Earasi

Posted 12/20/2005 5:30:25 AM

Forum Newbie

Group: Forum Members
Last Login: 12/21/2005 3:44:00 AM
Posts: 4, Visits: 1

HI,

We are not getting full SQL from DBQL tables.
We are able to findout only 200 Charecters of that Query.

Please let us know, how can we find the full SQL Query from DBQL table.

Regards,
Nagesh Earasi.

Post #3208

Divvy

Posted 1/3/2006 1:22:11 AM

Forum Guru

Group: Forum Members
Last Login: 3/27/2007 5:35:00 AM
Posts: 58, Visits: 1

Hi

Just remember to occasionally clean out those DBQL tables in DBC, it is possible to fill your DBC and run out of space if you are not careful. I suggest that you create a copy of them in another database and copy the data across from the DBC table to your new database tables and delete the data in the DBC tables. Rememebr to do it by date, something like this:

Delete from DBC.DBQLExplainTbl where CollectTimeStamp >= '2005-10-03 00:00:00' and CollectTimeStamp <= '2005-10-06 23:59:59';
Delete from DBC.DBQLObjTbl Where CollectTimeStamp >= '2005-10-03 00:00:00' and CollectTimeStamp <= '2005-10-06 23:59:59';
Delete from DBC.DBQLogTbl where LogonDateTime >= '2005-10-03 00:00:00' and LogonDateTime <= '2005-10-06 23:59:59';
Delete from DBC.DBQLSqlTbl Where CollectTimeStamp >= '2005-10-03 00:00:00' and CollectTimeStamp <= '2005-10-06 23:59:59';
Delete from DBC.DBQLStepTbl Where CollectTimeStamp >= '2005-10-03 00:00:00' and CollectTimeStamp <= '2005-10-06 23:59:59';
Delete from DBC.DBQLSummaryTbl where CollectTimeStamp >= '2005-10-03 00:00:00' and CollectTimeStamp <= '2005-10-06 23:59:59';

Hope this helps

MArtin

That's All Folks

Divvy

Certified TeraData Master

Post #3282

« 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 11:22am