Warning : Unbalanced input
Posted: Mon Jul 16, 2007 10:32 am
I have a Job Design which looks like this
I'm getting the following warnings which werent issued before:
Three other jobs append to the dataset created in this job(in Overwrite) mode. The weird thing is, if the dataset is deleted and this job is run , the warning is NOT issued. But if this job is re-run after the other three jobs have run(without dataset delete) then this warning is being issued.
Any idea why this would be happening? I tried other search results but couldnt see how I could apply the provided solutions to this problem.
Thanks in advance![Smile :)](./images/smilies/icon_smile.gif)
Code: Select all
INCOMING->Merge->Merge-(hash,unique sort)->Lookup->rest->DataSet
All Merges and Lookups have a DB2 API stage as the master link and reference link respectively. Lookup stage and DB2 API stages are constrained to 1 node.
I'm getting the following warnings which werent issued before:
Code: Select all
APT_ParallelSortMergeOperator,0: Unbalanced input from partition 0: 10000 records buffered
APT_ParallelSortMergeOperator,0: (no further unbalance warnings will be issued for this partition)
APT_ParallelSortMergeOperator,0: Unbalanced input from partition 2: 10000 records buffered
APT_ParallelSortMergeOperator,0: (no further unbalance warnings will be issued for this partition)
Any idea why this would be happening? I tried other search results but couldnt see how I could apply the provided solutions to this problem.
Thanks in advance
![Smile :)](./images/smilies/icon_smile.gif)