All Forums Teradata Studio
27 May 2014
Huge number of sessions with data transfer

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?

fgrimmer 553 posts Joined 04/09
27 May 2014

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?

You must sign in to leave a comment.