DSXchange

I have a simple job like the following:

Sequential file ----> Copy-----> DB2 connector.

I'm loading the data from source file into one DB2 table. Now I'm running the DB2 connector in parallel mode.Now the following questions.

1. What is the difference in DB2 and DB2 connector type in the partition method?
2 If I want to execute any Before/After SQL then will that also execute in parallel as this SQL only executes once?

1) Of these only the first exists. "DB2 connector type" is not an available partitioning algorithm.

2) Try it with an innocuous SQL statement (such as a select of the current date) to determine whether it's executed from each node or only once.