topic Re: vx_nospace when sorting data in Operating System - HP-UX

vx_nospace when sorting data

Susan W Roden — Mon, 23 Oct 2000 13:50:39 GMT

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?

Re: vx_nospace when sorting data

Andreas Voss — Mon, 23 Oct 2000 13:53:14 GMT

Hi,

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

Regards

Re: vx_nospace when sorting data

James R. Ferguson — Mon, 23 Oct 2000 13:56:17 GMT

Hi:

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

...JRF...

Re: vx_nospace when sorting data

Victor BERRIDGE — Mon, 23 Oct 2000 13:58:09 GMT

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

Re: vx_nospace when sorting data

CHRIS_ANORUO — Mon, 23 Oct 2000 14:11:58 GMT

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