I have problems with Shared Memory. Only 5 or 6 users can login at the same
time at database using shared memory INFORMIXSERVER. All run ok changing
them to tcp... but they are running a 4gl app and I want them throw
INFORMIXSERVER shm.

I check the sqlhosts and NETTYPE and I think all it's ok (anyway I post
them here).

Sqlhosts
ids_dc onipcshm districn ids_dc_shm
ids_dc_net onsoctcp districn s_ids_dc

Onconfig
DBSERVERNAME ids_dc # Name of default database server
DBSERVERALIASES ids_dc_net # List of alternate dbservernames
NETTYPE ipcshm,1,50,NET # Configure poll thread(s) for nettype
NETTYPE soctcp,1,60,CPU # Configure poll thread(s) for nettype

What can I do????

TIA


sending to informix-list

Diego Morales wrote:

How many CLEANERS have you got?
--
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

On Fri, 12 Sep 2003 13:38:19 +0200, "Diego Morales"
<dmorales (AT) districenter (DOT) es> wrote:

Does some kind of error return from your application?

4

-----Mensaje original-----
De: owner-informix-list (AT) iiug (DOT) org [mailtowner-informix-list (AT) iiug (DOT) org]En
nombre de Obnoxio The Clown
Enviado el: viernes 12 de septiembre de 2003 14:46
Para: informix-list (AT) iiug (DOT) org
Asunto: Re: Problems with Shared Memory


Diego Morales wrote:

How many CLEANERS have you got?
--
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

sending to informix-list

Yes, -25588.
$ finderr -25588
-25588 The appl process cannot connect to the database server server-name.

But it's not true because some users are connected to. No ISAM-Error
associated.

TIA.

-----Mensaje original-----
De: owner-informix-list (AT) iiug (DOT) org [mailtowner-informix-list (AT) iiug (DOT) org]En
nombre de John Carlson
Enviado el: viernes 12 de septiembre de 2003 15:42
Para: informix-list (AT) iiug (DOT) org
Asunto: Re: Problems with Shared Memory


On Fri, 12 Sep 2003 13:38:19 +0200, "Diego Morales"
<dmorales (AT) districenter (DOT) es> wrote:

Does some kind of error return from your application?

sending to informix-list

U r limited to 50 connections in all ... if you are using SHM connections
.... are the users spawning more than one connection to the engine when they
run the program ... I would suggest increasing the number of connections to
say 100 to see if it works or not ...

onstat -g ses and onstat -u will help pinpoint the problem.

Thanx much,

Rajib Sarkar
Advisory Software Engineer (RAS)
IBM Data Management Group
Ph : (602)-217-2100
Fax: (602)-217-2100
T/L : 667-2100

As long as you derive inner help and comfort from anything, keep it --
Mahatma Gandhi



"Diego Morales"
<dmorales@distric To: <informix-list (AT) iiug (DOT) org>
enter.es> cc:
Sent by: Subject: Problems with Shared Memory
owner-informix-li
st (AT) iiug (DOT) org


09/12/2003 04:38
AM
Please respond to
dmorales






I have problems with Shared Memory. Only 5 or 6 users can
login at the same
time at database using shared memory INFORMIXSERVER. All run ok changing
them to tcp... but they are running a 4gl app and I want them throw
INFORMIXSERVER shm.

I check the sqlhosts and NETTYPE and I think all it's ok
(anyway I post
them here).

Sqlhosts
ids_dc onipcshm districn ids_dc_shm
ids_dc_net onsoctcp districn s_ids_dc

Onconfig
DBSERVERNAME ids_dc # Name of default database server
DBSERVERALIASES ids_dc_net # List of alternate dbservernames
NETTYPE ipcshm,1,50,NET # Configure poll thread(s) for nettype
NETTYPE soctcp,1,60,CPU # Configure poll thread(s) for nettype

What can I do????

TIA


sending to informix-list


sending to informix-list

On Fri, 12 Sep 2003 17:05:46 +0200, "Diego Morales"
<dmorales (AT) districenter (DOT) es> wrote:

Shouldn't the SHM nettype be associated with a CPU poll thread??

Diego Morales wrote:

Well, then, I can only assume that your users fire up multiple connections
to the engine, or you have some other things connecting via SHM. The reason
why you can get away with it on TCP connections is that when the engine
runs out of TCP connections, it adds more. When you run out of SHM
connections, you're poked. Try

NETTYPE ipcshm,1,250,CPU # Configure poll thread(s) for nettype


--
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche