AGGR Warning

ds_is_fun · Post by **ds_is_fun** » Fri Apr 15, 2005 9:15 am

Im running DB2 as source and the PX job has a aggregator stage. I have turned the run time column propagation off.
It still gives me this error
AGGR1: When checking operator: User inserted sort "AGGR1.INPUT_REC4_Sort" does not fulfill the sort requirements of the downstream operator "APT_SortedGroup2Operator in AGGR1"
Thanks!

roy · Post by **roy** » Sun Apr 17, 2005 4:14 am

Hi,
It was alread covered, do a search.

rcil · Post by **rcil** » Sun Apr 17, 2005 10:48 am

Here I am trying to give some ideas and not sure where it solves your problem.

Is your source and Agg have the same sort order? If it is not match the sorting columns and sort the order on both and try see if it works.

Good Luck