Cannot connect slave sessions

[bell]

when i tested an ETL job, I got the error:
-------------------
Cannot connect slave sessions
Error(success check) Info = 0, Code = 2633, Message = Too many load/unload tasks running: try again later
----------------------------------

who tell me:

how many fastloads will be invoked when an ETL job is running. The job include one teradata enterprise stage. And the configuration file has 4 logic nodes.

thanks! :D

[JoshGeorge]

This is a TeraData side issue. The number of fastload / multiload / fastexport (block operations) that you can do concurrently is controlled by the limit set in the "dbscontrol" record - MaxLoadTasks. This limit depends on the database release and the local settings. When this limit is breached you get this message - "2633 Too many load/unload tasks running: try again later" . Suggest you to contact your DBA to know about the limit set and request to increase this limit if you really require to. Else limit your concurrent TeraData utility utilization within the limits.

[bell]

JoshGeorge,thanks for your answer.

I know the fastload limit in Teradata Database. Now i want to know how many fastloads will be invoked when the TD enterprise is running. Thus,I can control the number of the job that is going to be invoked.

by test, i find that when an ETL job is running, there are 20 sessions. I don't know the relationship between the fastload and TD enterprise and the relationship between the fastload and session.

[JoshGeorge]

Depends on the number of TD Enterprise stages you have in your job. So you can count the utility slot by counting the number of stages used per job. Not sure if your job is having some statements written in Before and after sql (open and close command) option available in Enterprise stage to invoke some of the TD utilities (Wonder if that is possible), you might have to cross check that.
TD Enterprise stage does loading in multiple steps by first loading into an temp empty TD Table and then append/load to the orginal specified table.

[quote="bell"]i want to know how many fastloads will be invoked when the TD enterprise is running. Thus,I can control the number of the job that is going to be invoked.
[quote]

[bell]

JoshGeorge, i very appreciate your help

i will test the job.

my job just has one TD enterprise stage that load data to TD database in create mode.

Thank U !


[quote="JoshGeorge"]Depends on the number of TD Enterprise stages you have in your job. So you can count the utility slot by counting the number of stages used per job.

[JoshGeorge]

In that case things are straight forward, FastLoad supports only one target table, so TD enterprise stage initiate/invoke only one fastload per stage.