Archives of the TeradataForum
Message Posted: Fri, 24 Jan 2003 @ 12:05:29 GMT
| 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