Date:         Sat, 13 Apr 2002 01:40:46 -0700
Reply-To:     yogesh <yogesh.shah@TATAINFOTECH.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         yogesh <yogesh.shah@TATAINFOTECH.COM>
Organization: http://groups.google.com/
Subject:      Re: Error while Creating MDDB
Content-Type: text/plain; charset=ISO-8859-1

Cassell.David@EPAMAIL.EPA.GOV (David L. Cassell) wrote in message news:<OFFD2A86EA.E2831E6C-ON88256B99.00769610@rtp.epa.gov>...
> yogesh <yogesh.shah@TATAINFOTECH.COM> wrote [in part]:
> >    When we are trying to build MDDB from a table with multi million
> > distinct records after a long processing time PROC MDDB gives error
> > that memory exhausted and process aborted even though space is
> > available in work space of SAS.Unix Data warehouse server has 2GB RAM
> > and around 4GB Page file.when we tried same thing on windows with some
> > test data (Code is given below) we found that whenever PROC MDDB
> > procedure utility file or temp file larger than RAM size it start
> > dumping into Swap file of operating system instead of SAS utility file
> > in work area. I have tried VMEMsize and PKSIZE option but it is no
> > use.
>
> Well, when files get bigger than RAM, you *want* SAS to off-load
> the information to disk.  If SAS is putting the files in your /tmp
> partition, then that may be where your sysadmin pointed the SASWORK
> directory.  If so, then point your SASWORK directory to a large chunk
> of free space.  If not, then mount your /tmp partition someplace huge,
> so that there is plenty of room for the temporary files.
>
> BTW, if you think SAS is a memory pig, just try ARC/INFO ...  :-)
>
> HTH,
> David

Hi David,


SAS is offloading information to the disk ,not in work area but in
system page file or swap file ...how to redirect this to work area...



Yogesh