Terdata Connector Parameter values

abhilashnair · Post by **abhilashnair** » Thu Oct 30, 2014 1:14 am

Hi

We are using teradata connector as target stage.
The databse version is TD14

What would be the optimum values for following parameters from a performance perspective

tenacity,
max partition session,
session
sleep time

chulett · Post by **chulett** » Thu Oct 30, 2014 7:44 am

No clue. Have you asked your DBA?

ray.wurlod · Post by **ray.wurlod** » Thu Oct 30, 2014 6:00 pm

It depends on a number of factors, including the number of AMPs available in Teradata. Work with your DBA (and, if you have one, a DataStage practitioner experienced with Teradata).

You can get some benefit too from the IBM Knowledge Center, or the Connectivity Guide for Teradata Databases manual.