All Forums Tools
20 Dec 2005
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.

XTUPIE 42 posts Joined 11/05
03 Jan 2006

HiJust 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 helpsMArtin

Regards
Divvy

You must sign in to leave a comment.