Archives of the TeradataForum

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

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

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>>