Re: Can SAPDB handle databases up to 500 GB and which hardware is required?

[Detlef Schulze]

Hi,   yes, there are some pseudo-files in /proc/sys/kernel you can modify (shmmax and shmall). On redhat you can change the values in /etc/sysctl.conf to make the changes permanent, not sure if this works on other distros as well.     So if you have 1 GB (1073741824 bytes) of memory and want to use 50% of it for shared memory:   echo 536870912 > /proc/sys/kernel/shmmax   does the job (remember: this is the proc fs, these changes won't survive a reboot)   You also might have to tweak the values for semaphores (I am not sure if this brings any advantage with SapDB, but I had to do it with Oracle). Does anybody know if this should be done with SapDB as well?       Since I am not in the office at the moment all I have right now is a link to a script that does this for Oracle (on RH 7.2), but you can modify it to meet your needs:   https://listman.redhat.com/pipermail/enigma-list/2002-November/017918.html   Remember: Google is your friend :-)     hth Detlef     ----- Original Message ----- From: Martin Cordova S. To: Detlef Schulze ; [EMAIL PROTECTED] Sent: Friday, March 28, 2003 4:02 PM Subject: Re: Can SAPDB handle databases up to 500 GB and which hardware is required? Hi, do you have a sample script to configure the shared memory in Linux? Is it a /proc/sys command?   Regards, Martin