Archives of the TeradataForum

Message Posted: Fri, 10 Mar 2006 @ 20:06:03 GMT

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

Anomy,

The max number of load jobs that you can run concurrently is limited by the maxloadtasks setting in DBS control, I think that the max in V2R6.0 and earlier is 15 and this increases to 30 in V2R6.1 onwards.

The number of sessions is limited to a maximum of 120 per Parsing Engine, I believe this is the same on V2R5 and R6, although you need to account for other concurrent jobs whilst the loads are running which will also use sessions.

The above should allow you to work out the maximum number of concurrent jobs that you could run, but I would rather understand why you have a need to run so many concurrent jobs and would probably look at a change to the ETL processes before trying to max out the number of sessions.

I hope you find the above useful.

Richard.

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