Archives of the TeradataForum

Message Posted: Sat, 31 May 2003 @ 13:31:51 GMT

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

I have started automating a lot of the data collection from DBC for reporting purposes. Since this process was going to be automated, I was wondering if anyone knew what tables could be cleaned up from the DBC and if this could be done via SQL? I have been cleaning up the old data through teradata manager now. If I can do it via SQL, I can obviously automate it.

Some of the tables I can think of are the resusage tables, ampusage, diskspace, logonoff, etc.

Thanks for the help.

Craig

www.wescodist.com/

Craig Ferry
Database and Unix Administrator
WESCO Distribution, Inc.

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