vx_nospace when sorting data

[Susan W Roden]

I have a user that gets the error vx_nospace - /dev/vg00/lvol5 ( which is where /tmp is mounted)file system full. A write error occurred while sorting.
This happens each time the user trys to sort a data file that is 51,100 records. It happens under three separate logon's. Could it be that I need to extend the /tmp directory?

[Andreas Voss · Accepted solution]

Hi,

extending /tmp is one solution.
For sorting you can define per option a different filesystem for temporary files:
sort -T /var/tmp ....

Regards

[James R. Ferguson]

Hi:

Set and export TMPDIR with the directory name in which you want to sort.

...JRF...

[Victor BERRIDGE]

Yes it looks like it, many progams create large temporary files to perform sort, of course once the sort is done the temp file is removed...
Extend /tmp, or if you have enough space create a file system just for that usage if it a regular situation (daily?), i have done so on one box where SAS is running, I can tell you that when it sorts 300MB it needs 700 to perform its task...

Best regards
Victor

[CHRIS_ANORUO]

Extend the /tmp and also check the permissions on the directory (drwxrwxrwx) owner must be bin and group also should be bin.