Write Error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
New2DS
Participant
Posts: 33
Joined: Sat Jun 26, 2004 9:58 am

Write Error

Post by New2DS »

Hello All,

I was using a ExecSH as a before routine in which I used a sort command to sort the specific columns. In development it worked perfectly well and in UAT it failed leaving the error.
sort: A write error occurred while sorting.
The command I used is

Code: Select all

sort -k5,5 -k10,10 -k1,1 file1 file2 > file3
Is this a permissions problem? or anything wrong in the command I used. The file contain around 20 million records.

-thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I'd say you ran out of space. Where are your 'temp' records going during the sort? You should redirect that out to someplace with plenty o' space, I think that is the -t option - check the man pages.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Also, try to run the command directly from your command shell - it should give the same error and is certainly a lot easier to debug.
New2DS
Participant
Posts: 33
Joined: Sat Jun 26, 2004 9:58 am

Post by New2DS »

You guys are great!!!!!! It was the space issue and I used the -T option and it worked fine. I should have thougth of this before but we learn new things from experience.

thanks
Post Reply