Page 1 of 1
Error in parallel data extraction using a user-defined query
Posted: Fri Sep 24, 2004 1:17 pm
by sswarup
hi,
We are getting the following error while trying to extract data in parallel using a user-defined query (in a DB2 Enterprise Stage)
main_program: Fatal Error: Multiple calls to setNodeMap() must specify the same numberOfPartitions.
Help!
Posted: Fri Sep 24, 2004 5:20 pm
by ray.wurlod
Welcome aboard! :D
What this message appears to be telling you is that you have specified X partitions in your query but Y partitions in your PX configuration file for the job. And that the rule is that X must equal Y.
The only remedy is to make sure that the rule is obeyed. You can change either or both the query or the configuration file. (It's not necessary to use the same configuration file for every job; indeed, it's probably unwise: small jobs can probably be managed better on one node.)
Posted: Tue Sep 28, 2004 1:24 pm
by gh_amitava
Hi,
If you use a user defined query in DB2 enterprise stage, Datastage works in sequential mode. Instead of using user defined query use the "Read Method = Table" and use the "Table", "Select" and "Where" clauses under this. Then it will work in parallel. In large volumn testing, you will find a huge performance difference in these two methods.
Regards
~Amitava