load_operator: TPT10517: At least 1 instance could not connect special sessions

Tools
Highlighted
Teradata Employee

Re: load_operator: TPT10517: At least 1 instance could not connect special sessions

It's a bit unusual (but not impossible) for multiple instances of the LOAD operator to make that much difference with tbuild.

 

You might also investigate simply allocating more sessions to the job but keeping the number of instances the same; e.g. QueryBandSessInfo='UtilityDataSize=Large;' is configured for this purpose by default.

 

Teradata Employee

Re: load_operator: TPT10517: At least 1 instance could not connect special sessions

Your feedback was not clear.

Which version took 4 hours, and which version took 8 hours?

 

-- SteveF
Enthusiast

Re: load_operator: TPT10517: At least 1 instance could not connect special sessions

To clarify: If I put on the script this code: TO OPERATOR (load_operator[1]) the task takes 8 hours and ends without any problem. If I put on the script this code: TO OPERATOR (load_operator[11]) how it was before, the task show the initial error that I reported. I'm thinking to put TO OPERATOR (load_operator[2]).. any ideas? thank you
Teradata Employee

Re: load_operator: TPT10517: At least 1 instance could not connect special sessions

I do not think you answered the question of how many sessions you are allowed to connect.

That would be the maximum number of instances you could use (because each instance has to connect at least 1 session).

Having an instance connect just one session is not ideal.

You want to achieve parallelism by having an instance control more than one session.

 

The Load operator does not have to use very many instances to be effective. Although performance is based on quite a few factors (CPU bandwidth, network bandwidth, disk I/O speed, number of sessions available for use, etc.).

 

It is really rare that you would ever need 11 instances of the Load operator. And from the original error, you do not even have 11 sessions to work with (else the orginal error would not have occurred). Thus you have <= 10 sessions to work with. That is not very many sessions to get any type of good performance.

 

You indicated that the job with one instance took 8 hours.

Did you try 2 instances?

 

I would also talk to your sysadmin to see if you can get allocated more sessions for your job.

How many AMPs are available on your system?

 

I think you can also get more sessions by submitting a query band with the load job to indicate to TASM that your job is a "large" job.

Talk to your sysadmin or DBA.

 

-- SteveF
Enthusiast

Re: load_operator: TPT10517: At least 1 instance could not connect special sessions

Well, I'm not very experience in Teradata. I'm a little bit confused with those concepts. I will check again those concepts: instance session parallel AMP do you have some link for dummies on teradata? About the ticket: I have modified 2 scripts from 11 to 2 instances. I did this on LOAD_OPERATOR([xx]) statement. and Will request the execution of those jobs the next week. I have 86 AMPs doing this: sel hashamp()+1; 86 We have VWP and our connections limit are: fastload: 30 multiload: 30 fastExport 60 backup: 350 I think could have been some jobs that requested resources at the same time. I'm the DBA. :s and I'm working on this database but I'm a newbie on Teradata Any other ideas? or we have wait execution with load_operator(2) ? thanks again
Teradata Employee

Re: load_operator: TPT10517: At least 1 instance could not connect special sessions

If you have 86 AMPs, then you have 86 sessions to work with.

 

But since your job terminated, with an error when running with 11 instances of the Load operator, that at least one instance could not connect sessions, this tells me that something limited the number of sessions you could use.

 

This could be due to TASM.

If you run tlogview on the job that failed, you will be able to see if there was an override.

 

   tlogview -j <job-id> -f "*" -g

 

or you can simply do this:

 

   tdlog <job id>

 

 and redirect the output to a file.

If you can/want, post the output here and we can take a look.

 

-- SteveF