hi
when ever i run server jobs i will get warning message that job is aborted.actually what is it?how can i solve this problem.
sai
Job aggregator aborted.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard! :D
The Aggregator stage, as you'll discover by searching this Forum, is notorious for not coping with large (or even medium) volumes of unsorted data.
Workarounds are:
The Aggregator stage, as you'll discover by searching this Forum, is notorious for not coping with large (or even medium) volumes of unsorted data.
Workarounds are:
- pre-sort the data to be aggregated (for example using ORDER BY when selecting from a database) - but avoid the Sort stage for this task for it, too, has memory problems
avoid the Aggregator: use an intermediate database stage instead (a UV stage will do); insert the raw rows and then select from the other side using regular SQL syntax (GROUP BY and aggregate functions)
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.