Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 10 Jul 2001 @ 08:03:36 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Cleaning out Resusage Tables
From:   David Wellman


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.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020