I left the partition type = auto (default value) as it is. I have read somewhere if we choose/left "Auto", the datastage engine will apply either "Same" or "Round Robin". How to know which one will be applied by datastage?
(Auto) ::= Round Robin if sequential -> parallel
Entire on reference input to Lookup stage
DB2 on input link to DB2 stage of any kind (parallel execution)
Same if parallel -> parallel
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Why don't you choose the one you want instead of using auto? If you're curious as to what it does when you use auto look at the dump score. It will tell you the partition method.
Sequential ---> ANY Parallel (except as noted - ref input to Lookup, input to DB2)
More information in the Advanced DataStage class from IBM. Not sure where it exists in the documenatation suite, but it has to be in there somewhere. Have you looked in the Information Center?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Nearly every section in the Parallel Job Developer's Guide repeats the descriptions of all the partitioning and collecting options. If IBM would pull all that into one section, it may cut the full doc size in half. Read the product manuals, and you can't miss it.
Choose a job you love, and you will never have to work a day in your life. - Confucius