|
|
Archives of the TeradataForum
Message Posted: Sat, 31 May 2003 @ 13:31:51 GMT
Subj: | | Cleaning up DBC tables |
|
From: | | Ferry, Craig |
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.
| |