Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: DBQL just a WEE BIT large
From:   Mahalingam, Subrahmanyam - Subrahmanyam

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).



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019