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.
Does only SORT stages generates Tsort merger abort erros?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Fri May 21, 2004 4:22 pm
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
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>
<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>
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
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>
<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>