Skip to Content
0
Former Member
Jul 19, 2007 at 02:53 PM

MaxDB memory allocation doubts

89 Views

Hi,

I installed the MaxDB 7.6.2.10 on IBM System x3400 with 5GB of RAM, and one Intel Xeon QuadCore processor installed, with Red Hat Enterprise Linux 5 and kernell 2.6.18-8.1.6.el5PAE.

i tried to configure CACHE_SIZE to use 2GB of RAM with that i get many messages like:

2007-07-16 11:54:41 3184 ERR 8 RTEMem No more system pages for 134221824 bytes available,BYTE_SIZE=4096,DESCRIPTION=posix_memalign,ERRORTEXT=ENOMEM ? out

2007-07-16 11:54:41 3184 ERR 8 RTEMem of memory

2007-07-16 11:54:41 3184 ERR 11 RTEMem + Used 2673582080 bytes from system heap with a limit of system imposed limitation bytes,ALLOC_COUNT=519,FREE_CO

2007-07-16 11:54:41 3184 ERR 11 RTEMem + UNT=0,ERROR_COUNT=2,BYTES_MAX_USED=2807803904

2007-07-16 11:54:41 3184 ERR 8 RTEMem No more system pages for 134221824 bytes available,BYTE_SIZE=4096,DESCRIPTION=posix_memalign,ERRORTEXT=ENOMEM ? out

2007-07-16 11:54:41 3184 ERR 8 RTEMem of memory

2007-07-16 11:54:41 3184 ERR 11 RTEMem + Used 2672009216 bytes from system heap with a limit of system imposed limitation bytes,ALLOC_COUNT=519,FREE_CO

2007-07-16 11:54:41 3184 ERR 11 RTEMem + UNT=3,ERROR_COUNT=3,BYTES_MAX_USED=2807803904

2007-07-16 11:54:41 3184 ERR 54008 MEMORY TransContext T186 : could not allocate

2007-07-16 11:54:41 3184 ERR 54008 MEMORY memory

2007-07-16 11:54:41 3184 ERR 54008 MEMORY required : 134217744

2007-07-16 11:54:41 3184 ERR 54008 MEMORY allocated : 917504

2007-07-16 11:54:41 3184 ERR 54008 MEMORY supplement : 134221824

2007-07-16 11:54:41 3184 ERR 54008 MEMORY limit : -1

then i changed the CACHE_SIZE to 1GB the errors above goes out but in database messages i get some messages:

Used memory exceeds physical memory installed (970 MBytes)

from what place the MaxDB see that 970 MBytes since the system have 5GB of RAM? and how i can increase CACHE_SIZE and dont have that allocation errors?

thanks for any idea.

Clóvis