8.1 Db2 Warning - to run in parallel without using the NODEN

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
akarsh
Participant
Posts: 51
Joined: Fri May 09, 2008 4:03 am
Location: Pune

8.1 Db2 Warning - to run in parallel without using the NODEN

Post by akarsh »

Hi,
In my job i am extracting data from Db2 EE stage and using partitioning table option. My query is like

SELECT Col1, col2
FROM Tab A INNER JOIN Tab B ON
( A.Col1 = B.Col1 AND A.REPORT_DT=B.REPORT_DATE ) WHERE A.ID = '1234'
AND A.REPORT_DT = 'YYYY-MM-DD'
AND dbpartitionnum(A.Col1) = current dbpartitionnum FOR FETCH ONLY WITH UR

while extarcting the data i am getting below warning
to run in parallel without using the NODENUMBER clause to localize the query;
this may result in extracting multiple copies of the answer set
leading to incorrect results and sub-optimal performance.

Previously i was not getting this warning. Please help how to remove these.
Thanks,
Akarsh Kapoor
Post Reply