Archives of the TeradataForum
Message Posted: Mon, 07 Sep 2009 @ 11:37:18 GMT
Why we need to set the value maxloadtask ...yes we set this to make sure that at a given time there exists maximum of 15 slots for fastload/mload jobs to load the data...what happens if we do not set this feature ???
can i assume some thing like this
Assuming ::no othere sessions are logged on to TD box
Total Nodes ::8
Assuming 2 PE 'S per node which corresponds to max of 240 sessions per node
total session =8*240
total AMPS = 80 AMPS
AMPS per each node =10
Default fast load/Mload sessions =80
i.e total of 24 fast loads jobs can run at a time If we do not set maxload task limit...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|