Re: Connections to Informix 7.x

David Williams wrote: > > In article <4vpo3q$bv6@nic.global-one.no>, Nils Myklebust <Nils.Myklebus > t@ccmail.telemax.no> writes > >71242.3522@compuserve.com (John Graas) wrote: > > > >:Is there any limitation to the number of simultaneous open connections > >:that I can have to Informix 7.x or Informix XPS?? I'm looking at an > >:application that may require 3,000 connections. > > > >OnLine 7.2: About 33.000. Max number of open tables per OnLine DS > >system is 32.000 though that may set a lower limit for you, but there > >should still be no problem with 3,000 connections on this account. > >You will also need a recommended average virtual shared memory of 250 > >kb per session (given minimum is 35 kb per session) according to the > >technical spesifications. There may be other limitations. > > > >You'll easily find all this and a lot more at http://www.informix.com > >under the products heading. > >I don't know the numbers for XPS, but wouldn't expect them to be any > >lower :-) > > > > > > > >Nils.Myklebust@ccmail.telemax.no > >NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway > >My opinions are those of my company > > > > If you are running across a TCP/IP network. i.e. programs do not run on > the same machine as the database server then the limit is about 2,000 > (at least I've heard about this on Solaris). This is because you cannot > open >~2,000 sockets at the same time due to a HARDCODED kernel limit. > > -- > David WilliamsWe are running approximately 3000 connections under HPUX 10.10. There WAS a limitation in previous HPUX versions of 1800 or so connections. This was even true as of version 10.01. We did find a new bug in HPUX 10.10 using Informix 7.12 which they have finally resolved but I would recommend that you ask specifically for this patch if you are planning on using 10.10. Good luck in your efforts, Jason C. Freedman jfreedman@andersen.com