Page 1 of 1

Datastage error Scratch space full

Posted: Sun Jul 30, 2006 11:34 pm
by kkreddy
Dear DSGurus,
when i am running the Job sequence i am getting the following errors
Can any one explain me what for the following errors

APT_CombinedOperatorController(0),0: Failure during execution of operator logic

APT_CombinedOperatorController(0),0: Fatal Error: Tsort merger aborting: Scratch space full



and also how to overcome this ,


Thanks in advance
KK

Re: Datastage error Scratch space full

Posted: Sun Jul 30, 2006 11:43 pm
by balajisr
It specifies that there are not enough temporary space available for sorting.
Increase your disk space used in sorting.

Posted: Mon Jul 31, 2006 12:11 am
by pigpen
Also try to increase the size or point to another bigger disk of scratchdisk specified in configuration file. :o

Posted: Mon Jul 31, 2006 1:30 am
by ray.wurlod
You don't overcome it. You prevent it.

Make sure that the scratch disk mentioned in your configuration file has more than enough space. If not, add more scratch disk (on other file systems!) to each processing node.

Posted: Mon Jul 31, 2006 4:32 am
by kumar_s
Check with the input file size. Try to give atlest twice as large as that, if you have only one sort stage(that is where the current abort is in) in the job. Bear in mind that, the stages like, lookup, sort, remove duplicate, aggregator will use the scratch sapce. So more you of these staeg utilization, will lead to more memory shortage.