Archives of the TeradataForum
Message Posted: Tue, 10 Jul 2001 @ 08:03:36 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|