Date: Thu, 28 Sep 2000 09:48:02 +0530
Reply-To: Deepak Mathur <Deepak.Mathur@ORANGE.CO.IN>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Deepak Mathur <Deepak.Mathur@ORANGE.CO.IN>
Subject: More on Sizing - How to ?
Thanks for your suggestions.
My original mail is also attached below this note, kindly give suggestions
with these settings:
The following settings on present my system -
in config.sas612, memsize=256m
ulimit -a shows :
memory(kbytes) 32768 (-- is this the problem ?)
I again mention my system config :
Site details : SAS 6.12 on AIX 4.2.1 (RS/6000) 512 MB RAM
MDDB Details (the problem one) :
Dimensions : 17 Measures : 35
Cells (Nway) : 291,620
Rows in summary dataset : 3,632,434
If I increase the memsize to the maximum (say 512MB in my case), and set the
memory limit to maximum (512MB) , can it create any problems for system
performance etc ?
> -----Original Message-----
> From: Deepak Mathur [SMTP:Deepak.Mathur@ORANGE.CO.IN]
> Sent: Tuesday, September 26, 2000 12:36 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Sizing - How to ?
> Importance: High
> Hi all,
> I am facing a problem. I have a huge summary dataset on which I create a
> MDDB. The summary dataset is appended with a snapshot of some data every
> month. The MDDB uses month and year as a dimension.However, for the past
> months the PROC MDDB is unable to generate the MDDB, and gives the error
> "Unable to perform function, memory exhausted".
> I have been asked to suggest the memory upgrade required.Note that it is
> possible for me to split the MDDB etc right now. I am willing to invest in
> H/w resources.
> At this point, I need to know the following:
> 1. How does one find cardinalities ?
> 2. How does one estimate the memory required to generate a particular MDDB
> 3. What other problems can cause the error I've mentioned above ?
> 4. Does Proc MDDB use swap ? my swap is hardly used when I run PROC MDDB.
> Site details : SAS 6.12 on AIX 4.2.1 (RS/6000) 512 MB RAM
> MDDB Details (the problem one) :
> Dimensions : 17 Measures : 35
> Cells (Nway) : 291,620
> Rows in summary dataset : 3,632,434
> Thanks in advance,
> Knowledge is Power.
> Deepak Mathur, IT
> Extn: 5079