SQL Query - DBQL table

Tools & Utilities

SQL Query - DBQL table

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.
1 REPLY
Enthusiast

Re: SQL Query - DBQL table

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