Archives of the TeradataForum
Message Posted: Mon, 16 Jan 2006 @ 22:27:44 GMT
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).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|