Getting warning in DB2 stage

[skp]

Hi I am getting the below warning

"StageName": You have specified the query: `Query'
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.

In the query where clause i am doing DBPARTITIONNUM(COLUMN_NAME) = CURRENT DBPARTITIONNUM

Please let me know the reason and solution for this....

[nayanpatra]

While creating the table is the table data partitioned? Then the distribution of data among database partitions is not as desired. Also, if the database is data partitioned then a better approach is to search in a particular data partition itself. Example: Suppose a table is data partitioned based on the LOAD DATE and it is say monthly partitioned. Then it is better to fetch the data from the particular month where it resides.

[chulett]

Did you try searching for DBPARTITIONNUM here? There are a handful of other discussions that mention it, something there might help.