FastLoad parallel sessions limit. Is it overridable?

Tools & Utilities
N/A

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.

1 REPLY
Teradata Employee

Re: FastLoad parallel sessions limit. Is it overridable?

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