can i see what this "APT_CombinedOperatorController&quo

zulfi123786 · Post by **zulfi123786** » Sun Jan 18, 2009 11:08 pm

Hi,
when i use the APT_RECORD_COUNTS environment variable it shows this operator "APT_CombinedOperatorController" consuming a lot of cpu.
Is it possible for me to know what this combined operator is doing???

miwinter · Post by **miwinter** » Sun Jan 18, 2009 11:29 pm

Yes, you need to dump out the score and verify what this combined operator involves. This is all advanced stuff though which you should really attend the vendor course for to gain an appreciation. It is also covered in the documentation,as most things are.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 19, 2009 3:52 pm

My guess is that you have an example of over-enthusiastic operator combination occurring. This will always be the case with operator combination - it is as aggressive as it can be under the rules for combining operators (the operators must be adjacent and share the same degree of parallelism on the same set of nodes).

To ameliorate this situation, selectively make one or more of the stages non-combinable. To find out which ones, disable operator combination totally and monitor the job to determine the resource consumption. Then combine such that demand for resources is not excessive from any of your new combinations of operators, once operator combination has been re-enabled.