 |
 |
Archives of the TeradataForum
Message Posted: Tue, 10 Jul 2001 @ 08:03:36 GMT
| Subj: | | Re: Cleaning out Resusage Tables |
| |
| From: | | David Wellman |
Patricia,
In the past I have always warned against using Multiload to purge Resusage tables or indeed any tables in DBC. This is because if the
Multiload task fails during Apply phase then you have a locked table which has to be dropped and re-created. With most of the system
tables, this means a Sysinit!
However, since release 'X' of Teradata/Multiload (no, I can't remember which one), you are able to issue the "Release MLoad" command even
if the task failed during the Apply phase. Having said that, the user (i.e. you) then have to ensure data integrity etc etc. Personally, I
still wouldn't use Multiload against a system table.
Cheers,
Dave
| |
