Datastage error Scratch space full

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
kkreddy
Participant
Posts: 28
Joined: Tue May 10, 2005 6:00 am

Datastage error Scratch space full

Post 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
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Re: Datastage error Scratch space full

Post by balajisr »

It specifies that there are not enough temporary space available for sorting.
Increase your disk space used in sorting.
pigpen
Participant
Posts: 38
Joined: Thu Jul 13, 2006 2:51 am

Post by pigpen »

Also try to increase the size or point to another bigger disk of scratchdisk specified in configuration file. :o
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post 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.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply