All Forums Tools
Dec0de 1 post Joined 09/13
08 Jan 2015
FastLoad parallel sessions limit. Is it overridable?

Many of you are already know, that Teradata has only 30 CONCURRENT Fast-Load slots awailable. In other words, it means that you can have only 30 simultanious dataflows for loading data, not more.
For our division it turned into bottleneck, because we need much more parallel transfers. Sometime, our sources (OLTP database for example) are situated many miles away and therefore very slow.

So, please, share your experience, how do you overcome this? Maybe there are any hidden tricks that we don't know?
Thanks.

feinholz 1234 posts Joined 05/08
12 Jan 2015

There is no way to override this.
(The limit was 5, then was raised to 15, and now it is 30.)
It is found that trying to run more than 30 concurrent FastLoad/MultiLoad jobs can actually slow performance of the Teradata RDBMS severely, and thus Teradata imposes the limit.
 

--SteveF

You must sign in to leave a comment.