Kernel Parms for Sybase 12.0 and HPUX 11.0 (32 Views)
Reply
Occasional Advisor
Robb Bailey
Posts: 26
Registered: ‎03-26-2001
Message 1 of 5 (32 Views)

Kernel Parms for Sybase 12.0 and HPUX 11.0

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
Please use plain text.
Super Advisor
Martha Mueller
Posts: 198
Registered: ‎12-08-1999
Message 2 of 5 (32 Views)

Re: Kernel Parms for Sybase 12.0 and HPUX 11.0

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
Please use plain text.
Super Advisor
Martha Mueller
Posts: 198
Registered: ‎12-08-1999
Message 3 of 5 (32 Views)

Re: Kernel Parms for Sybase 12.0 and HPUX 11.0

Would you care to post a sample of the errors?
Please use plain text.
Advisor
Ed Mitchell_1
Posts: 10
Registered: ‎06-13-2002
Message 4 of 5 (32 Views)

Re: Kernel Parms for Sybase 12.0 and HPUX 11.0

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
if it ain't broke, don't patch it.
Please use plain text.
Occasional Advisor
Robb Bailey
Posts: 26
Registered: ‎03-26-2001
Message 5 of 5 (32 Views)

Re: Kernel Parms for Sybase 12.0 and HPUX 11.0

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
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation