Date:         Sat, 23 Apr 2005 15:01:43 -0500
Reply-To:     "A. Michielsen" <amichielsen@COMCAST.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "A. Michielsen" <amichielsen@COMCAST.NET>
Organization: Your Company
Subject:      Re: SAS v9.1.3 (Unix work space not big enough)
Comments: To: sas-l@uga.edu

There is a lot of variations under unix - from version to version
and from vendor to vendor.  Generally, this is not a SAS problem,
but a unix hardware/software/os/install problem.

First, remember if you are going to sort a 1.5GB dataset - you'll
need to be able to create a file perhaps as large as 5GB (2-3x+
of the original) - as a temp file.  Try changing the sort to a
tagsort - I expect it will run fine then (but slow).

A 2GB limit is quit common - so to avoid the need to use a
tagsort - you'll need to be certain that both the user privs,
disk directory/format/partitioning/mount points will allow and
support files larger than 2GB.

Generally, a 2GB 'limit' can be applied/implemented a number of
different ways.  As a user limit or as a inherent limit of the
filesystem.  You can validate/test that by creating a file that
exceeds the 2GB limit - and you should (generally) find that it
stops (dies) prett cleanly at the 2GB (2x1024x1024x1024) byte
count.

[posted and mailed]

Patrice.Bourdages@IAAH.CA (Patrice Bourdages) wrote in
news:A3DBB423A2D29143BA00E9A2276B95130F2DC4@liaqc29.ia.iafg.net:

> Hello to you all...
>
> We're in the process of changing our old Unix serveur (Enterprise
> 3500) to a new one with a lot of muscle (don't recall the model). As
> we're testing the new solution, we encountered a very strange problem
> and don't know if the problem is SAS or the operating system (Solaris
> 10).
>
> One of the testing user got an error message stating that there is not
> enough work space available for sorting a table (something like that).
> The user is suppose to create and sort a 1.5 GB table in is work
> directory on the Unix server. The strange thing is that we have 260 GB
> left on this disk array.
>
> Do you have any idea where the problem is...?
> Is this a SAS or Unix problem ?
>
> I've checked the installation this morning with the network manager
> and found nothing out of the ordinary. I'm not familiar with Solaris
> 10 nor SAS v9.1.3 (service pack 2) since we're making test to figure
> out if everything is ok.
>
> TAI for any replies that might help
>
>
> Patrice Bourdages
> Information System Analyst
> Industrial Alliance, home and car insurance
> Phone: (418) 650-4600, extension 3216
> Fax: (418) 650-4636
> EMail: patrice.bourdages@iaah.ca
>