Setting buffer pool memory size ? error starting database

, ,
1

We have set Buffer pool size to 1024 MB but want to increase it. We are able to set it to the maximum of 1800 MB, but when we start the database we get the following error:
Shared memory of size 2002234504 is not available (operating system error 22) - INODSF1688

Looking in windows task manager I can see that we have 3362516 K of available physical memory, so there should be enough memory. So what goes wrong?

We are running Tamino 4.1.4 under windows 2000 server.

Many regards from Ole

InterResearch A/S - Vestergade 9 - DK-1456 Copenhagen K
Phone: +45 70 27 28 72 - Mobile: +45 20 10 21 74 - Fax: +45 70 27 28 79
E-mail: oen@interresearch.dk - Homepage: http://www.interresearch.net

2

Hello Ole,
Could you please raise this issue with Software AG Denmark’s Customer Support service?
Thanks.

3

Hi,

the curcial point is the virtual memory, not teh physical one. Windows currently supports only
32 bit addressing, giving 4 GB of virtual memory, of which normally 2 GB are available for user processes. These 2 GB have to accomodate some Windows DLLs, all DLLs of the application, and all memory that the application allocated in excess. As a consequence,
there is not too much space left for the buffer pool. The real limit even depends on the version of the operating systems - our experiments show that on Windows 2000 you should be able to get around 1200 MB in most cases. If you are above the limit, you will encounter the message that you
report. So you can do some experiments to find out the maximum size you can set on your machine. Again, the limit is independent of the physical memory in the machine (although it is not advisable to configure more memory for the buffer pool than is physically available, this is possible). On a 64bit UNIX, you will not encounter such limitations.

Regards

Harald

4

Hi Harald,

Thanks a lot. We are soon upgrading to Windows 2003 server. Have you done any experiments with Tamino memory usage there? So that we might be able to allocate more buffer pool size under that OS version.

Regards from Ole

InterResearch A/S - Vestergade 9 - DK-1456 Copenhagen K
Phone: +45 70 27 28 72 - Mobile: +45 20 10 21 74 - Fax: 70 27 28 79
E-mail: oen@interresearch.dk - Homepage: www.interresearch.net

5

Hi Ole,

unfortunately I do not have any numbers for Windows 2003, but I don’t expect the numbers to change a lot.

Regards

Harald