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.
8.1 Db2 Warning - to run in parallel without using the NODEN
Moderators: chulett, rschirm, roy
8.1 Db2 Warning - to run in parallel without using the NODEN
Thanks,
Akarsh Kapoor
Akarsh Kapoor