Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 25 Apr 2006 @ 20:46:35 GMT


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


Subj:   Re: Performance issue in Mload (with INMOD)
 
From:   smishra2

Rishi,

Looks like there are too many Mload jobs running on your client machine at the same time. Since you have upgraded your server, number of AMP has been increased. Hence each Mload trying to establish more number of sessions ( one session per AMP) than that of before the upgradation. You might have to reduce the number of concurrent Mload jobs. Or you can control the number of sessions through Mloadcfg.dat. Sometime it is better to have less number of sessions than the default one per AMP particularly for large Teradata configuration where Mload would end up spending more time to establish the number of sessions than the actual load.

Performance Problem: Provided all other parameters are constant, it could be a network issue as Acquisition Phase is taking more time.



     
  <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