Executing multiple TPT scripts simultaneously will yield to better perfomance?

Tools & Utilities
Teradata Employee

Re: Executing multiple TPT scripts simultaneously will yield to better perfomance?

Every operator attribute is exposed to tdload.

However, TrimColumns is only for the file reader. Not for the file writer.

 

-- SteveF
Enthusiast

Re: Executing multiple TPT scripts simultaneously will yield to better perfomance?

Thanks Fred,

 

Fred, I am testing my TPT script on AWS teradata Instance and it has 2 node, 6AMP system.

its taking 16 mins to export 1.6 GB of data. I tried to set MaxSessions to 6 each for source and target.

 

Can it be increased or I will get same output

Teradata Employee

Re: Executing multiple TPT scripts simultaneously will yield to better perfomance?

If you are using the Export operator for extracting the data out of the database, then you cannot increase the number of sessions.

The Export operator supports a max of 1 session per available AMP.

And for loading, the Load and Update operators also only support a max of 1 session per available AMP.

 

-- SteveF
Enthusiast

Re: Executing multiple TPT scripts simultaneously will yield to better perfomance?

Ok,

I was able to export 2.5 GB in less than 5 minutes. And I have defined export instance as 4 and maxSessions as 24.

But can not make it more faster

Enthusiast

Re: Executing multiple TPT scripts simultaneously will yield to better perfomance?

Also, We have tables FallBack protected having size 30GB. Its not even starting to run.

Enthusiast

Re: Executing multiple TPT scripts simultaneously will yield to better perfomance?

Hi team,

 

There are few more questions I have.

 

1) Should we use Bteq in place of TDload for smaller tables.

2) Decimal 56.90 is stored as 56.9 in files and I need to have zero at the end too for data validation.Is it possible. Also, if there is any digit such as 56.62, it is coming fine in Tdload as well as Fast export. Please assist