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 ?
Content-Type: text/plain

Hi all,

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 :
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         131072
stack(kbytes)        32768
memory(kbytes)       32768  (-- is this the problem ?)
coredump(blocks)     2048
nofiles(descriptors) unlimited

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

Also,

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 ?

Regards,
Deepak.

> -----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
> big
> 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
> two
> 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
> not
> 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,
> Deepak
>
> _________________________________________________________________________
> Knowledge is Power.
>
> Deepak Mathur, IT
> Extn: 5079
> Orange:18299
> _________________________________________________________________________
>