Huge number of sessions with data transfer

Teradata Studio
Teradata Employee

Huge number of sessions with data transfer

Hello

I copied some smaller tables from production to test environment. The problem is the usage of over 60 session for this job, which is blocking other production jobs.

Is there a way to limit the number of sessions for data transfer?

regards

Markus

1 REPLY
Teradata Employee

Re: Huge number of sessions with data transfer

Markus, The Data Transfer, for large tables (over 100,000 rows), will use the JDBC FastLoad and FastExport option.  It will create a separate connection and set the JDBC FastLoad/FastExport parameter option. According to the JDBC Reference, the FastLoad/FastExport will create sessions based on the number of AMPs. "The default value is 8 or the number of AMPs if the number of AMPs is less than 8." If the number of rows is less, than the connection will perform a JDBC Batch insert instead. I am not sure how it can cause 60 sessions since we only perform one data transfer at a time?