Hi all,
I am joining a database table(db2) with a pre-build dataset in the join stage. I am getting the following error :
Fatal error :- Tsort merger aborting .Scratch space full..
I also used modify stage before joining bcoz my dataset col. and table col. where different.Also while executing the job the data is only being Fetched from the Table(i.e it shows 4219818 row fetched and then modified in Modify stage) but shows 0 rows fetched from dataset
Please help me to resolve this issue.
Thanks
Fatal Error:--Scratch Space Full
Moderators: chulett, rschirm, roy
If you search this forum, you can easily find that you may either need to increase the temp space or cleanup the temp space for this error.
You may also find that the link followed by Modify to Modify or to Peek statge doesn't show up the statistics.
And moreover, you will not get the exact number when the job is aborted.
You may also find that the link followed by Modify to Modify or to Peek statge doesn't show up the statistics.
And moreover, you will not get the exact number when the job is aborted.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Hi Ajmore,
As Kumar and samsuf2002 suggested first check the scratch space.
One more thing I have identified is you are getting warning on Tsort operator. If your Database and Dataset are sorted before Join stage and If you are sure abot that, then use the environment variable APT_NO_SORT_INSERTION=True. It will remove the datastage default Tsorting.
May be it will helopful to you.
Regards
Nagesh
As Kumar and samsuf2002 suggested first check the scratch space.
One more thing I have identified is you are getting warning on Tsort operator. If your Database and Dataset are sorted before Join stage and If you are sure abot that, then use the environment variable APT_NO_SORT_INSERTION=True. It will remove the datastage default Tsorting.
May be it will helopful to you.
Regards
Nagesh
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............