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?
Regarding DB2 connector
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
Regarding DB2 connector
Soumya
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.