Semaphore error when logging into TSQL

murad · Post by **murad** » Wed Jul 23, 2003 5:09 pm

I am running HP 11i U/X and from time to time I am getting the following errror:

000 Unix will not allow more process to access semaphore
000 Unable to obtain semaphore
000 Could not open locking mechanism in the function ddopen
000 Couldn't connect to . in the function SQLConnect

I have 10 texis databases running and somewhere between 200-500 concurrent users. Do you know why I could be getting this error. My kernal settings related to semaphores are below.

Semaphore retated Kernel Parameters

semaem 16384
semmap 1026
semmni 1024
semmns 1536
semmnu 384
semmsl 2048
semume 256
semvmx 32767

Post by **John** » Wed Jul 23, 2003 5:44 pm

The semmnu 384 is the controlling one, and if more than that number of connections to any combination of databases exist you will get that message.