Archives of the TeradataForum

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

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

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