Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 21 Aug 2002 @ 20:01:43 GMT

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

Subj:   Re: Question on Deadlock..
From:   Meade, Cornelius

In my experience, archival and/or purging of the various log tables (such as SW_event_log, AccLog, EventLog, etc.) is up to the site. We have a practice of creating specific archival tables that we copy data into from the system tables and then purge/trim the system tables as necessary to keep them from getting too large. As for the archive/historical data tables we maintain, we keep varying amount of historical data in them depending on the type of data so in our case the answer to your first question would be yes but you will have to check your installation to see if you are doing anything similar....

  <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: 28 Jun 2020