Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 24 Jan 2003 @ 12:05:29 GMT

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

Subj:   Re: Data Retention of System Log Tables
From:   Doorey, Andrew ST

We archive acclogtbl daily and usually just need to look at the archived table as it is only missing the current day's data. The less data you have in this table the quicker it is for teradata to insert into it. We also found that if you allow the table to grow it can take a long time to delete from.

Another reason to archive it frequently is that the table becomes extremely skewed if users (or applications) leave their sessions logged on for a long time, as it's PI is the logon date and time. We insert the archived rows into a table with a PI of logdate, logtime which gives a much better distribution of rows.

We archive all the other log tables daily too for similar reasons, and so we don't use up the database space in DBC which is our spool reserve.

  <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