Archives of the TeradataForum

Message Posted: Mon, 16 Jan 2006 @ 22:27:44 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Deleting DBQL tables should not cause any problem.

Two steps for a cleanup job could be:

1. Insert select the rows to a private database if you want to keep some history. Consider using (empty) staging tables for optimized insert-select.

2. Delete DBC.DBQL* tables (except for the RuleTbl and RuleCountTbl which anyways you can't). If you are deleting based on date then use collectiontimestamp on all but DBQLogTbl. We use StartTime to delete from DBQLogTbl as the collectiontimestamp is way off in this table (may be a bug).

Thanks,

Subbu.

	<Prev	Next>		<<First	<Prev	Next>	Last>>