Archives of the TeradataForum
Message Posted: Wed, 11 Jul 2002 @ 01:08:50 GMT
| Subj: || || Re: Archiving Resusage Tables |
| From: || || Fenwick, Ruth |
There is no way to archive the tables via database DBC. There are only 12 tables in DBC that are archived: ACCLOGRULETBL, ACCOUNTS,
COLLATIONTBL ,DBASE, HOSTS,LOGONRULETBL, NEXT, OWNERS, PARENTS, RCCONFIGURATION, RCEVENT, and RCMEDIA.
I do an insert select into the same tables in another database and archive it. Comes in handy if you want to do a compare of before and
after an upgrade.
IA&DSS Team Leader, IRM
Hudson's Bay Company