DSXchange

Are you experiencing this behaviour with all the records or just few records? Increase the size a little bit more and see what happens. Lets debug this part first and then we shall look at fixing the size.

Nothings dumb. We learn through our mistakes.

Who created this file? Is it some external process or DataStage? And if datastage did, then did a server job create it or a px job?

Depending upon the conditions, build your insert/update logic and load it to a file (.sql). Then execute the .sql file from command line which you can do in after job subroutine using ExecSh.

Based on the parameters, sort them and do a row by row comparison. Search for comparison techniques.

Yes they are. You can do it at the unix level using uniq. But get your code fixed. Its not a woo-haa error that cannot be fixed. Do an exact search on "Tsort merger aborting" for more information.

Welcome Aboard
What stage are you using to pull the data? How did you import the table definition? If you do a select * from your favourite sql tool (TOAD or oracle developer) do you see the same behaviour?

He truely is. Time to mark your post as "Resolved".

Run your job then simultaneously keep running df -k /tmp to keep monitoring when it runs out. I know unix sort uses this directory by default. I am not sure what tsort uses.

Its the /tmp space that the tsort uses to store intermediate temp files. Send in sorted data and uncheck the option of "Perform Sort".

Was everyone signed off when you did REINDEX ALL? Try creating a job which was already present. If it does'nt allow you to do it that means the jobs are there. You need to run reindex again with everyone signed off from the server. If you are able to create an identical named job, that means your jo...

Get out of the director and go back in and clear the log. The display refreshes every several seconds. The warnings are already logged. Its just the display that is slow.

You sure the jobs are deleted or they are just not visible in the repository? Click on new, in the designer and go to the last tab, its called Recent Jobs, I think. You should see your most recently accessed jobs there. Click on any one and hit Open. If the job pops open, that means the jobs are the...

Look into sequential file stage. It has property of ebcidic to ascii in its properties, under format tab. See if that works. Else use server job as it has a function that converts PicS9 to ascii. That will work for you as I looked at zoned sample data here and its the same as as PicS9. I have done t...

A couple of ways:
-Merge stage
-Hashed file
-Loading your files to work tables and passing full outer join sql
Refer herefor more details on the first two.