Job gives Tsort merger aborting: Scratch space full

Credit_Inter · Post by **Credit_Inter** » Thu Oct 01, 2009 4:19 am

I have a small job where I am doing a left outer join between two tables in and then putting the values in a third table.
Even for a small ammount of data like 500,000 and 500,000 it is giving the error :Tsort merger aborting: Scratch space full.

I have done joins with 6 or 7 million records but never got this problem, but now even for such small data I'm getting the error.

Also the output for the above join is like 1.2 million records.

Please help.
Thanks!

ArndW · Post by **ArndW** » Thu Oct 01, 2009 4:24 am

Either pre-sort your data to reduce the required scratch sort space, or increase the size of your scratch disk or add additional scratch disks to your APT_CONFIG file for that run.