error while using sort stage

Make suggestions regarding the DSX site or the Forum

Moderators: chulett, rschirm, roy

Post Reply
ramesh_inform
Participant
Posts: 57
Joined: Mon Dec 03, 2007 12:43 am
Location: hyderabad

error while using sort stage

Post by ramesh_inform »

my design looks like this
DB2--
71000records
------------->
JOIN-------->DB2
---SORT---->-
DB2--
11million records

the error is Sort_11,3: Fatal Error: Tsort merger aborting: Scratch space full [sort/merger.C:874]

what does this error mean..

Help me................ :(
ramesh.n.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Please advise in what way this post could be regarded as a suggestion for improving the DSXchange site or forum.

If you can not, then please post your question in the appropriate forum.

Before you do that, read the error message carefully; it tells you precisely what your problem is. You might also search DSXchange for the error text; others have encountered it in the past.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
swapnilverma
Participant
Posts: 135
Joined: Tue Aug 14, 2007 4:27 am
Location: Mumbai

Re: error while using sort stage

Post by swapnilverma »

ramesh_inform wrote:my design looks like this
DB2--
71000records
------------->
JOIN-------->DB2
---SORT---->-
DB2--
11million records

the error is Sort_11,3: Fatal Error: Tsort merger aborting: Scratch space full [sort/merger.C:874]

what does this error mean..

Help me................ :(



while sorting your /pxscratch disk is getting full.. try to use some bigger config file or add more space in your scratch disk
Thanks
Swapnil

"Whenever you find whole world against you just turn around and Lead the world"
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Please do not answer questions manifestly in the wrong forum. It makes future searches more difficult.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply