Sybase Notes

Beatnik on 2005-08-24T23:09:34

Sybase on Linux needs different shared memory parameters..Define before installing:

sysctl -w kernel.shmmax=67108864

---

reboots?

Dom2 on 2005-08-25T06:58:05

Don't forget to put that into /etc/sysctl.conf or it'll stop working on the next reboot. Which is probably in 6 months time when the command has disappeared from you bash_history. :-)

-Dom

And Solaris

jplindstrom on 2005-08-25T12:31:24

Freebie from our operations wiki, if you're gonna do that on Solaris:

Check available memory (physical) on the server

# /usr/platform/sun4u/sbin/prtdiag -v | grep "Memory size"
Memory size: 5120MB

We make a decision to dedicate dedicate 4000MB for Sybase ASE and leave some 1GB plus for the OS for now. Next, we caluculate what will go in to the /etc/system file to be applied to the kernel at boot time 4000 * 1024 * 1024 = 4194304000 bytes. Next, we add this to the /etc/system file:

# vi /etc/system
set shmsys:shminfo_shmmax=4194304000

We need to reboot the Solaris OS now.

Once the server is built we'll need to tell the ASE how much shared memory it is allowed to use. Usually you'll let it use all of the shared memory we allocated above. Since ASE mostly deals with pages, we need to recalculate it into 2k-pages. 4194304000 / 2048 = 2048000 pages. Next, we add this to the ASE configuration file:

# vi $SYBASE/<SERVER>.cfg
 
max memory = 2048000

Reboot your ASE server now.