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>
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.email@example.com>...
> 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 ... :-)
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...