Date:         Fri, 12 Apr 2002 14:36:43 -0700
Reply-To:     Cassell.David@EPAMAIL.EPA.GOV
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "David L. Cassell" <Cassell.David@EPAMAIL.EPA.GOV>
Subject:      Re: Error while Creating MDDB
Content-type: text/plain; charset=us-ascii

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
--
David Cassell, CSC
Cassell.David@epa.gov
Senior computing specialist
mathematical statistician