Oninit cdi / Archive
Talk to an expert →

Re: NETTYPE setting give's a problem in no. of users

Posted in 1999

Mark D. Stock — — source: Informix-list mailing list archive (1991-1998)

Infodata Mails wrote: > > Hi All, > > We have installed IDS 7.3, 20 Users Licenses on Unix SCO Open Server ver 5.0 > machine, and 20 users 4GL RDS licenses. > > The problem we are facing is that when 4 users login to the database > the system works fine, when the fifth user log's in the system slows down, > after the sixth user log's in we get an error message "error number 25588" > and the system hangs. > > WE have kept the NETTYPE settings to (ipcshm,1,20,CPU). We are able to go > online. When we changed the setting to(ipcshm,1,45,CPU) > the number of login increased from 5 Users to 20 Users. If 21st user log's > in we get the same error "error number 25588" and the system hangs. Does > Informix give an error message if the number of login increases from the > specified no. of users ? I think for SHM connections there IS an error returned if you exceed the number of users specified in NETTYPE. Though I don't think it is -25588. Have you tuned your kernel parameters according to the release notes? > Since we are only having 20 users licenses for our engine, what is the exact > meaning of this error message ? Why the system is working at the value > (ipcshm,1,45,CPU) ? > > can anyone help us on this ? You might be confusing database connections with bums on seats. You might have 20 users, but how many database connections do they make? To check, look at onstat -g ses. onstat -u and onstat -g sql are other useful ones. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+

Related threads