Kernel Parms for Sybase 12.0 and HPUX 11.0

[Robb Bailey]

A vendor is trying to upgrade my L1000 with 3 GB RAM from Sybase 11.92 to 12.0. They can't get the server to start. The vendor is not very familiar with Unix and my only Sybase support is through them (the vendor). I have changed two parms - maxfile_lim (from 2047 to 3000) and maxfiles (from 2040 to 2900) and this seems to have helped. Are there other parms that I need to change as well? I am familiar with Oracle and we had a similar problem before and changed 5 or 6 as suggested in the install guide. I have not been able to find such a recommendation on the Syabase website.
I am attaching a list of the kernel settings. Any help is greatly appreciated as the vendor is stumped.

Thank you,

Robb

[Martha Mueller]

We had to set the kernel parm shmmax to use as much memory as was in the server. In your case, 3 GB. That allows sybase to use as much memory as you defined within the sybase configuration files. We also had to create /dev/async with the mknod command,
mknod /dev/async c 101 0x000005
change the owner to sybase, group adm. The minor number can vary, we use 4, but intend to use 5 soon. Also have sybase own all the logical volume devices, under /dev/vgxxx/lvolname. The big thing is, as root, run /etc/setprivgrp adm RTPRIO MLOCK CHOWN for sybase install.***NOTE this needs to be set at every boot for sybase to run. make sure to add the device driver asyncdsk to the kernel. Reduce dbc_max_pct down to about 10%. I think we had to increase max_dsize

[Martha Mueller]

Would you care to post a sample of the errors?

[Ed Mitchell_1]

Robb:
Here's what's workin' for us on a K360 - 1 Gb. memory:

* Tunable parameters

dbc_max_pct 10
maxfiles 120
maxswapchunks 1024
maxuprc 1024
maxusers 200
maxvgs 20
msgseg 3456
msgtql 256
nflocks 864
ninode 4640
nstrpty 60
semmni 864
semmns 1728
semmnu 432
semume 64
shmmax 734003200
shmmni 400
unlockable_mem 1000
STRMSGSZ 65535
nkthread 2048
max_thread_proc 256
ncallout 2064

[Robb Bailey]

Thank you for your response. I have changed maxfiles to 2900 and maxfiles_lim to 3000 and this seems to have helped.

Thank you for the other kernel parms. I will implement them if problems arise again.

Robb