Archives of the TeradataForum

Message Posted: Tue, 25 Apr 2006 @ 10:25:40 GMT


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

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

From:		Rishi Agarwal

Sandipan,

If we don't specify the SESSIONS parameter, it says -

     UTY0800 CLI error: DBCHCL returned 300.
     text: CLI2: NOMEM(300): Out of memory.

When session parameter is not specified, it takes 1 session per AMP and throws above error.

There was no change made at client side (ETL server - MPRAS) after the upgradation. Only change done was that client machine was moved to different location/LAN. I doubt if that is creating this much difference in performance. Moreover, performance bottleneck is there in "Acquisition phase" only i.e. INMOD processing is taking more time.

Thanks and Regards,

Rishi Agarwal