Kernel parameters for Sybase 12.5 running on HP-UX 11i

[JOHN FONTANILLA]

Hi,

I've searched through the forum and looked at
the archives. We have a problem of starting
up two Sybase servers using 2GB RAM each.
Let's call them "A" and "B"

We can start either "A" or "B" with 2GB but
the next one shows this error in the log:

00:00000:00000:2003/03/10 19:06:11.02 kernel Checked out license ASE_SERVER
00:00000:00000:2003/03/10 19:06:11.02 kernel Adaptive Server Enterprise Edition
00:00000:00000:2003/03/10 19:06:11.03 kernel Using config area from primary master
device.
00:00000:00000:2003/03/10 12:42:55.08 kernel os_create_region: can't allocate 1073635328 bytes
00:00000:00000:2003/03/10 19:06:11.04 kernel kbcreate: couldn't create kernel region.
00:00000:00000:2003/03/10 19:06:11.04 kernel kistartup: could not create shared memory

Starting the other database with just 300MB
will work though.

Here's our machine: Dome cell with 4 CPU
and 12GB RAM running HP-UX 11i with June 2002
Goldbase patches.

Here's our Sybase version:
Adaptive Server Enterprise/12.5.0.1/EBF 10427 ESD#2/P/HP9000-829/HP-UX 11.0/rel12501/1792/32-bit/FBO/Tue Jul 30 07:45:20 2002

Here are some kernel params:

dbc_max_pct 10
dnlc_hash_locks 512
ksi_alloc_max 12000
max_mem_window 0
max_thread_proc 256
maxdsiz 0X100000000
maxdsiz_64bit 0X100000000
maxfiles 2048
maxfiles_lim 2048
maxssiz 0X10000000
maxssiz_64bit 0X10000000
maxswapchunks 16384
maxtsiz 1073741824
maxtsiz_64bit 0X40000000
maxuprc 512
maxusers 1024
maxvgs 80
msgmap 15002
msgmax 32768
msgmnb 65535
msgmni 1500
msgseg 32767
msgssz 128
msgtql 15000
ncallout 5000
nfile 12000
nflocks 1500
ninode 8000
nkthread 3411
nproc 1500
npty 256
nstrpty 256
nstrtel 256
nswapdev 25
semmap 3602
semmni 7800
semmns 32767
semmnu (NPROC-4)
semume 256
shmmax 24884901888
shmmni 8192
shmseg 8192

Here's what we discovered: if we have max_mem_window set to a non-zero value, we can't start any of the Sybase servers with
2GB of RAM. Lower amounts of RAM work.

Right now we're playing around with the
values of the sh* kernel parameters but
running both servers are still not working.
and reboots take at least 20 minutes each. I
know shmmax is way too high (higher than
the 15GB of swap) but setting it to other values doesn't seem to make a difference.
I still have to adjust maxdsiz lower because
'sam' complains about the setting being
too high.

We already ran 'chatr -M' on the dataserver
binary file and I've read Bill Allen's
"Sybase and HP Tuning" document in Sybase's
web site a number times.

My question is: What the correct combination
of kernel parameter so we can have two
servers that use 2GB each?

We are restricted on using the 32-bit binary
due to deadlines. We can't just jump to
64-bit Sybase...

If you need more info. pls. let me know. Thanks!

JohnF

[Michael Steele_2]

Semaphores and shared memory are the big ones:

For 1 gig of RAM:

shmni=200
shmseg=120
nfile=910
nflocks=200

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x79b653921f1ad5118fef0090279cd0f9,00.html