|
|
Archives of the TeradataForum
Message Posted: Fri, 07 Jul 2006 @ 14:05:04 GMT
Subj: | | Re: 104 TERADATA TABLES IN A SINGLE MLOAD |
|
From: | | Joseph V D silva |
| What version of TD are you using to get 15 mloads? I can only run 5 simultaneously in the background on one box. Any others submitted
during that time on that box wait for one of them to finish before it will start. | |
5 is the default allowed, you can raise that value to a max of 15 by setting the DBS control Record General field MaxLoadTasks = 15
Keep in mind that the more load/export tasks that are running, the more resources are being hogged by them which will hinder the performance of
other applications. That's one reason why they have put a max limit of 15.
Joseph Vinish D'silva
| |