Search Box

Google

Sunday, December 10, 2006

Number maxim of concurrent conexions
All 8 messages in topic - view as tree
From: lossanchez - view profile
Date: Fri, Aug 25 2006 9:22 am
Email: "lossanchez"


Hello:
I have a problem when in my IDS 9.40 in Linux System 32 Bytes have more
than 1100 conexions.
Which is the max conexions for IDS? There are any parameter in the
Operatym System for more conexions or only it's a limit of Informix?
Thank you

Reply Rate this post: Text for clearing space


From: scottishpoet - view profile
Date: Fri, Aug 25 2006 10:47 am
Email: "scottishpoet"

in general there is no "limit" on the number of informix users


it is more likely you have hit some resource limit


what error message occurs? what behaviour are you experiencing



- Hide quoted text -
- Show quoted text -

lossanchez wrote:
> Hello:
> I have a problem when in my IDS 9.40 in Linux System 32 Bytes have more
> than 1100 conexions.
> Which is the max conexions for IDS? There are any parameter in the
> Operatym System for more conexions or only it's a limit of Informix?
> Thank you


Reply Rate this post: Text for clearing space


From: Obnoxio The Clown - view profile
Date: Fri, Aug 25 2006 11:13 am
Email: "Obnoxio The Clown"

lossanchez said:



> Hello:
> I have a problem when in my IDS 9.40 in Linux System 32 Bytes have more
> than 1100 conexions.
> Which is the max conexions for IDS? There are any parameter in the
> Operatym System for more conexions or only it's a limit of Informix?


What is your problem? (What makes you think you have a problem, and how
does it show itself?)

What are the NETTYPE settings in your onconfig?


--
Bye now,
Obnoxio


"... no bill is required as no value was provided."
-- Christine Normile


Reply Rate this post: Text for clearing space


From: Martin Fuerderer - view profile
Date: Fri, Aug 25 2006 11:16 am
Email: Martin Fuerderer


Hi,

the only place where IDS actually enforces number of connections
is via the NETTYPE parameter in onconfig file. Please see the
manual for more information on this (or past e-mails in this list ... :)


However there are other possible reason for a restriction:


- number of open files when soctcp connection protocol is used,
because for each socket connection a file descriptor is needed.
This usually is an OS parameter.


- SHM (segment) limitations when ipcshm protocol is used.
Each SHM connection needs some SHM in the "message segment(s)".
If running out of SHM it will impose a limit.


That's what currently comes to my mind.
The actual error and circumstances may reveal more insight.


Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management


IBM Information On Demand Global Conference
October 15-20, 2006, Anaheim, California
see http://www.ibm.com/events/informationondemand


informix-list-boun...@iiug.org wrote on 25.08.2006 09:22:48:



- Hide quoted text -
- Show quoted text -

> Hello:
> I have a problem when in my IDS 9.40 in Linux System 32 Bytes have more
> than 1100 conexions.
> Which is the max conexions for IDS? There are any parameter in the
> Operatym System for more conexions or only it's a limit of Informix?
> Thank you

> _______________________________________________
> Informix-list mailing list
> Informix-l...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list



Reply Rate this post: Text for clearing space


From: lossanchez - view profile
Date: Fri, Aug 25 2006 12:01 pm
Email: "lossanchez"


I have defined shm and tcp, for shm run ok, but for tcp not ok.
I don't know the ifx error because I can't reproduce it.
The users say me than the error is 'can not open more files' more or
less.
I don't know if the problem is for the system can't allocate more
socket, or if the problem is for any parameter del /proc (max-file...)


- Hide quoted text -
- Show quoted text -

Martin Fuerderer wrote:
> Hi,

> the only place where IDS actually enforces number of connections
> is via the NETTYPE parameter in onconfig file. Please see the
> manual for more information on this (or past e-mails in this list ... :)


> However there are other possible reason for a restriction:


> - number of open files when soctcp connection protocol is used,
> because for each socket connection a file descriptor is needed.
> This usually is an OS parameter.


> - SHM (segment) limitations when ipcshm protocol is used.
> Each SHM connection needs some SHM in the "message segment(s)".
> If running out of SHM it will impose a limit.


> That's what currently comes to my mind.
> The actual error and circumstances may reveal more insight.


> Regards,
> Martin
> --
> Martin Fuerderer
> IBM Informix Development Munich, Germany
> Information Management


> IBM Information On Demand Global Conference
> October 15-20, 2006, Anaheim, California
> see http://www.ibm.com/events/informationondemand


> informix-list-boun...@iiug.org wrote on 25.08.2006 09:22:48:


> > Hello:
> > I have a problem when in my IDS 9.40 in Linux System 32 Bytes have more
> > than 1100 conexions.
> > Which is the max conexions for IDS? There are any parameter in the
> > Operatym System for more conexions or only it's a limit of Informix?
> > Thank you


> > _______________________________________________
> > Informix-list mailing list
> > Informix-l...@iiug.org
> > http://www.iiug.org/mailman/listinfo/informix-list



Reply Rate this post: Text for clearing space


From: Adam Tauno Williams - view profile
Date: Fri, Aug 25 2006 2:31 pm
Email: Adam Tauno Williams



On Fri, 2006-08-25 at 03:01 -0700, lossanchez wrote:
> I have defined shm and tcp, for shm run ok, but for tcp not ok.
> I don't know the ifx error because I can't reproduce it.
> The users say me than the error is 'can not open more files' more or
> less.
> I don't know if the problem is for the system can't allocate more
> socket, or if the problem is for any parameter del /proc (max-file...)


How about looking at the log file, or onstat -m?

Reply Rate this post: Text for clearing space


From: Adam Tauno Williams - view profile
Date: Fri, Aug 25 2006 2:34 pm
Email: Adam Tauno Williams



> the only place where IDS actually enforces number of connections
> is via the NETTYPE parameter in onconfig file. Please see the
> manual for more information on this (or past e-mails in this list ... :)
> However there are other possible reason for a restriction:
> - number of open files when soctcp connection protocol is used,
> because for each socket connection a file descriptor is needed.
> This usually is an OS parameter.


On Linux you can see this value with "/sbin/sysctl fs.file-max", it is
unlikely to be the issue on a 2.6.x kernel as the default is very high.
Perhaps you can ulimits applied to the Informix user?


> - SHM (segment) limitations when ipcshm protocol is used.
> Each SHM connection needs some SHM in the "message segment(s)".
> If running out of SHM it will impose a limit.
> That's what currently comes to my mind.
> The actual error and circumstances may reveal more insight.


Same, like the above "/sbin/sysctl kernel.shmmax". But my guess is
NETTYPE values need to be increased.

Reply Rate this post: Text for clearing space


From: Martin Fuerderer - view profile
Date: Fri, Aug 25 2006 2:49 pm
Email: Martin Fuerderer


Hi,

you may see some errors in the online.log (message) file of the server.


If users already "point to" 'can not open more files' and as it is with
sockets/tcp protocol only, I'd definitely look in that area (i.e.
respective
UNIX kernel parameters) ...


Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management


IBM Information On Demand Global Conference
October 15-20, 2006, Anaheim, California
see http://www.ibm.com/events/informationondemand


informix-list-boun...@iiug.org wrote on 25.08.2006 12:01:20:




- Hide quoted text -
- Show quoted text -

> I have defined shm and tcp, for shm run ok, but for tcp not ok.
> I don't know the ifx error because I can't reproduce it.
> The users say me than the error is 'can not open more files' more or
> less.
> I don't know if the problem is for the system can't allocate more
> socket, or if the problem is for any parameter del /proc (max-file...)

> Martin Fuerderer wrote:
> > Hi,


> > the only place where IDS actually enforces number of connections
> > is via the NETTYPE parameter in onconfig file. Please see the
> > manual for more information on this (or past e-mails in this list ...
:)


> > However there are other possible reason for a restriction:


> > - number of open files when soctcp connection protocol is used,
> > because for each socket connection a file descriptor is needed.
> > This usually is an OS parameter.


> > - SHM (segment) limitations when ipcshm protocol is used.
> > Each SHM connection needs some SHM in the "message segment(s)".
> > If running out of SHM it will impose a limit.


> > That's what currently comes to my mind.
> > The actual error and circumstances may reveal more insight.


> > Regards,
> > Martin
> > --
> > Martin Fuerderer
> > IBM Informix Development Munich, Germany
> > Information Management


> > IBM Information On Demand Global Conference
> > October 15-20, 2006, Anaheim, California
> > see http://www.ibm.com/events/informationondemand


> > informix-list-boun...@iiug.org wrote on 25.08.2006 09:22:48:


> > > Hello:
> > > I have a problem when in my IDS 9.40 in Linux System 32 Bytes have
more
> > > than 1100 conexions.
> > > Which is the max conexions for IDS? There are any parameter in the
> > > Operatym System for more conexions or only it's a limit of Informix?
> > > Thank you


> > > _______________________________________________
> > > Informix-list mailing list
> > > Informix-l...@iiug.org
> > > http://www.iiug.org/mailman/listinfo/informix-list


> _______________________________________________
> Informix-list mailing list
> Informix-l...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list



Reply Rate this post: Text for clearing space


End of messages

No comments: