Oninit cdi / Archive
Talk to an expert →

RE: Problems with Shared Memory

Posted in 2003

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Networking & sqlhosts Configuration

Diego Morales — — source: Usenet: comp.databases.informix

4 -----Mensaje original----- De: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]En nombre de Obnoxio The Clown Enviado el: viernes 12 de septiembre de 2003 14:46 Para: informix-list@iiug.org Asunto: Re: Problems with Shared Memory Diego Morales wrote: > > > 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???? 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

↪ replying to Diego Morales
Obnoxio The Clown — — source: Usenet: comp.databases.informix

Diego Morales wrote: > 4 > > -----Mensaje original----- > > Diego Morales wrote: > >> 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. >> >> NETTYPE ipcshm,1,50,NET # Configure poll thread(s) for nettype>> >> What can I do???? > > How many CLEANERS have you got? 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

Glossary