topic increase the value for MAXMEMQUERY in Administration and Deployment

increase the value for MAXMEMQUERY

Viraaj — Thu, 26 Jan 2017 00:41:32 GMT

Hi All,

One of our SAS user trying to run the proc varcomp and they getting below error message in SAS log:

ERROR: Unable to allocate sufficient memory. At least 2097152K bytes were requested, but only
2097150K were available. You must either increase the amount of memory available, or approach
the problem differently.

I have added -MAXMEMQUERY MAX on SAS config file (sasv9.cfg), still giving the same error how can I fix this problem? Please, anyone, help me out on this.

Re: increase the value for MAXMEMQUERY

SASKiwi — Thu, 26 Jan 2017 01:24:09 GMT

MEMSIZE is the option to adjust here. 2G for MEMSIZE is a bit low these days. Try -MEMSIZE 3G. There is no guarantee this will fix the error. With statistical procedures like VARCOMP, simplifying the analysis is often required.

Re: increase the value for MAXMEMQUERY

Viraaj — Thu, 26 Jan 2017 01:41:38 GMT

Thanks for the response. I have tried -MEMSIZE 3G and -MEMSIZE MAX, it doesn't work.

Re: increase the value for MAXMEMQUERY

SASKiwi — Thu, 26 Jan 2017 03:33:04 GMT

What does "it doesn't work" mean? Does it actually change the MEMSIZE setting - you can confirm this by using PROC OPTIONS. Or does it successfully change the setting but VARCOMP still fails?