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?
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?