Archives of the TeradataForum

Message Posted: Sun, 19 Oct 2003 @ 10:41:14 GMT


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

Subj:		Re: Multiple Sessions

From:		David Wellman

Hi Bill,

For Bteq there are very few circumstances when multiple session buys you anything. In most circumstances only the first session that is logged on that actually does any work. Where you have a data file of records and each record is being processed by the same request(s) -- typically you'll have a .REPEAT command and a USING clause -- then multiple sessions are useful. Apart from this I'm not aware of any circumstances where Bteq really uses multiple sessions.

Not sure about the Fastload/Arc side of your questions etc. These will typically use all of the sessions that are logged on, so your issue may be one of reporting rather than usage.

Cheers,

Dave