Does only SORT stages generates Tsort merger abort erros?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Salegueule
Participant
Posts: 35
Joined: Fri May 21, 2004 4:22 pm

Does only SORT stages generates Tsort merger abort erros?

Post by Salegueule »

Hi,

I am getting the following in my job output:
cs}}},2: Fatal Error: Tsort merger aborting: Scratch space full [sort/merger.C:870]

I know that increasing the scratch disk will resolved the problem but what I would like to know after reading on similar topics in this forum is; is it only the SORT stages that generates the Tsort merger aborting errors or does other stages like the join could also do it?

Thanks.
Minhajuddin
Participant
Posts: 467
Joined: Tue Mar 20, 2007 6:36 am
Location: Chennai
Contact:

Post by Minhajuddin »

I think even stages like Change Capture and others which use the tsort operator internally, i.e if the input data is not sorted generate the same error. Because they have the tsort operator in them.
Minhajuddin

<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Yes other stages like join, remove duplicates,... also can generate 'Tsort merger aborting errors'. Take a look at the score by adding APT_DUMP_SCORE parameter in your job. You can see which all operators insert Tsort (Datastage automatically insert OSH Tsorts in certain situations)
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Post Reply