Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 14 Oct 2011 @ 08:06:06 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Release mload is taking long time
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, October 13, 2011 21:20 -->

libin.jose wrote:

  I had tried with our data stage team members on this issue. When they removed the start up property from 'clean' to 'keep', I count not fine release mload statement in the query logs.  


  Please try this with your datastage teams and verify.  


  I believe clean mode in datastage issues drop temp tables (_ET, _UV, _log etc) and also issue Relase mload statement as well.  


  Please confirm if you get same results with your team.  


Hi Libin,

Thanks a lot for your solution. I was the one who raised this problem.

After no proper solution from IBM Datastage support and from Teradata support we tested on our own and did investigations. You are abosolutely right.

After we changed the startup property from start up property from 'clean' to 'RESTART' the release mload statement is no more seen in the accesslog and looks like the problem is solved for us. Our datastage team will be testing it soon.


Thx.



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