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
Datastage error Scratch space full
Moderators: chulett, rschirm, roy
Re: Datastage error Scratch space full
It specifies that there are not enough temporary space available for sorting.
Increase your disk space used in sorting.
Increase your disk space used in sorting.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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'