Archives of the TeradataForum

Message Posted: Wed, 02 Jun 2010 @ 13:09:08 GMT

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

Which Teradata Version you are using? It is basically depend upon the MaxloadTasks versus MaxloadAWT.

Please go through the below example and you will understand the combination and usage of MaxloadTasks versus MaxloadAWT -

Assume that MaxLoadAWT = 48 and MaxLoadTasks = 30. The list below shows some permitted combinations of load utility jobs. The limiting condition(s) for each combination is shown in bold:

- 16 FastLoads in Loading phase
16 concurrent load tasks
48 AWTs in use: (16 x 3)

- 9 FastLoads in Loading phase and 21 FastLoads in End Loading phase
30 concurrent load tasks
48 AWTs in use: (9 x 3) + (21 x 1)

- 24 MultiLoads in Acquisition phase
24 concurrent load tasks
48 AWTs in use: 24 x 2

- 5 MultiLoads in Acquisition phase and 25 MultiLoads in Application phase
30 concurrent load tasks 35 AWTs in use: (5 X 2) + (25 x 1)

- 6 FastLoads in Loading phase and 15 MultiLoads in Acquisition phase
21 concurrent load tasks
48 AWTs in use: (6 x 3) + (15 x 2)

Thanks,

Syed

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