I am getting the below warnings while execution of the job, job is running on 4 nodes.......Any explanation or how to avoid these errors
APT_ParallelSortMergeOperator: When checking operator: Operator of type "APT_ParallelSortMergeOperator": will partition despite the
preserve-partitioning flag on the data set on input port 0.
APT_ParallelSortMergeOperator,0: Unbalanced input from partition 0: 10000 records buffered
APT_ParallelSortMergeOperator,0: (no further unbalance warnings will be issued for this partition)
AGGR_SNO,0: Hash table has grown to 16384 entries.
APT_ParallelSortMergeOperator,0: Unbalanced input from parti
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
They're not errors, they're messages informing you about what's happening with your data so that you can perhaps optimize buffering and/or partitioning.
See earlier post and/or Search about "will partition despite preserve-partitioning flag".
See earlier post and/or Search about "will partition despite preserve-partitioning flag".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
So Search for "unbalanced input". There's even an FAQ on exactly this.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.