RE: Adding additional Listener ports

Cheers for that, next I'll a Clown RTFM'ing me. But at least I can rename my databases Paul Watson # WF Software Ltd # All answers are Tel: +44 1436 674729 # pure fantasy Fax: +44 1436 678693 # www.wfsoftware.com # > -----Original Message----- > From: Heiko Giesselmann [mailto:heiko.giesselmann@informix.com] > Sent: Thursday, August 03, 2000 6:07 PM > To: informix-list@iiug.org > Subject: Re: Adding additional Listener ports > > > "Watson, Paul" wrote: > > > Disagree, if you have a largish number of users that need > to log in a > > a relatively short period ie 1000 in five minutes then have multiple > > listeners on a single card does help. If you watch the q-exceed in > > onstat -g nt? then it tends to have an entry typically > around th 10-100,> > but if you see it go off the scale ie > 1000 then adding additional > > listeners definitely helps. > > > I have no idea what causes q-exceed to increment, and I've never got > > an answer from ITS. > > Hi, > > with later versions of the server administration manual there > should be a better > explanation with respect to q-exceed. In any case, there is a > short paragraph on > q-exceed in the MaxConnect manual (page 5-10 in > http://www.informix.com/answers/english/docs/10maxcon/6678.pdf ): > > "q-exceed: the number of times that the threshold for the > shared network > free-buffer pool was exceeded. In most cases, the value in > this columns should > be 0 ..." > > q-exceeds > 0 usually is an indication that there isn't > enough memory reserved > for the networking subsystem - which doesn't cause any > functional problems put > will have some impact on performance. Memory can be tuned > using the NETTYPE > parameter in ONCONFIG (bottom of page 5-9 of the MaxConnect guide). > > Anyway, additional listeners do provide better performance if you have > situations where hundreds of clients connect in a short > period of time - but if > you have hundreds of connections you should be looking into > MaxConnect anyway, > which would provide both better connect performance and > better throughput in > general. > > Hope this helps, Heiko > > > > > > > > > > -----Original Message----- > > > From: Mark D. Stock [mailto:mdstock@mydas.freeserve.co.uk] > > > Sent: Wednesday, August 02, 2000 11:43 > > > To: gary child > > > Cc: informix-list@iiug.org > > > Subject: Re: Adding additional Listener ports > > > > > > > > > gary child wrote: > > > > > > > > It has been suggested to me that adding additional Listener > > > ports to /etc/services > > > > and corresponding aliases to sqlhosts may provide a > > > performance gain by spreading > > > > user connectivity between the multiple listener ports. We > > > run 7.31.UC5 on > > > > HPUX11 and all connections via tcp. > > > > We do not use shared memory connections because we are > > > utilising HP Shmem_magic > > > > to address additional shared memory. > > > > > > Hang on, are you saying you are using TCP for local > connections? Why > > > don't you use stream pipes? Adding multiple listeners is > only really > > > useful if you have multiple network cards. I don't think > you are going > > > to see much gain with local connections unless you have > > > 1000's of users. > > > > > > > I don't recall ever seeing anyone suggest > > > > multiple listener ports as a tuning option so I'd be > interested to > > > > hear your thoughts. > > > > > > It is certainly a concept covered in the Sys Adm training course. > > > > > > Cheers, > > > -- > > > Mark. > > > > > > +----------------------------------------------------------+-- > > > ---------+ > > > | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk > > > |//////// /| > > > | http://www.informix.com http://www.informixhandbook.com > > > |///// / //| > > > | http://www.iiug.org > > > +-----------------------------------+//// / ///| > > > | |This email will self-destruct in > > > |/// / ////| > > > | |10 sec. If you received this email > > > |// / /////| > > > | |in error, sorry about the mess. |/ > > > ////////| > > > +----------------------+-----------------------------------+-- > > > ---------+ > > > > The contents of this e-mail are confidential to the ordinary user(s) of the mail address(es) to which it was sent and may be legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or use of it, or any part of it, in any form whatsoever, and any actions taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.